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...

Man and I thaught you were young, that makes you jump up 25 years . The new programmers just didn't face up with...

Well hopefully someone will know how to do it. Good luck.

Is it possible that the network be slower on one side (if the proc returns large amount of data).. or maybe it's just the app that process the data harder,...