Viewing 15 posts - 16,021 through 16,035 (of 18,923 total)
My mother, sisters and father would remember that one as they assisted my birth.
June 29, 2005 at 11:58 am
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...
June 29, 2005 at 11:57 am
Select top 25 percent Telephone from dbo.YourTable order by NewId() will do the job just fine.
June 29, 2005 at 11:55 am
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?
June 29, 2005 at 11:48 am
Yes, the date functions are stripping the time part using mathematical operations, which is faster than any cast you can come up with.
June 29, 2005 at 11:47 am
Select * from (LinkedServer).(Database).(Owner).(Table/view)
June 29, 2005 at 11:43 am
Still would like to see an MS certif exam where the answer is "it depends"... ![]()
June 29, 2005 at 11:42 am
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...
June 29, 2005 at 11:40 am
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...
June 29, 2005 at 11:39 am
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 : ...
June 29, 2005 at 11:37 am
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...
June 29, 2005 at 11:29 am
Man and I thaught you were young, that makes you jump up 25 years
. The new programmers just didn't face up with...
June 29, 2005 at 11:25 am
Well hopefully someone will know how to do it. Good luck.
June 29, 2005 at 10:49 am
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,...
June 29, 2005 at 10:47 am
Viewing 15 posts - 16,021 through 16,035 (of 18,923 total)