If there's no object in master, then maybe it is create twice in the same transaction... are you sure you got everything statement in that batch?

Then this is your friend :

Select top 25 percent Telephone from dbo.YourTable order by NewId()

Can't be simpler than that.

Anything wrong with that?

No he wants Select into. Insert would do fine but he doesn't want to have to create the table first.

My mother, sisters and father would remember that one as they assisted my birth.

Also here's and exemple of select the top pourcent from a group... not too sure it would cope well with a random sampling though :

SELECT O.XType

--, count(*) AS...

Select top 25 percent Telephone from dbo.YourTable order by NewId() will do the job just fine.

Is it echo in here?

could be... can you fire up the profiler, restart the process and reexecute in QA to have the actual error and more info on what's going on?

Yes, the date functions are stripping the time part using mathematical operations, which is faster than any cast you can come up with.

Select * from (LinkedServer).(Database).(Owner).(Table/view)

Still would like to see an MS certif exam where the answer is "it depends"...

sukhoi971, is it normal that we can still login with this injection technic, or you're simply using a bogus account??

If the later, then I would strongly suggest that you avoid...

Sample data is definitly required here... And why would you want to sort on the last 2 digits?? are those the extension of the phone number?

If yes, then I...

Definitly split them in 2 fields.

One for pourcentage : decimal (4,3), so a 5% increase would be entered as 1.05, 10% decrease would be 0.9.

Then one for amount : ...

First of all. Why do you have a table object in master?? You should have as little objects as possible in there. And mostly only admin stored...