Viewing 15 posts - 52,846 through 52,860 (of 59,064 total)
David Jackson (1/15/2008)
You can use a function with no cursor for this...
Nicely done, Dave...
January 16, 2008 at 9:08 pm
PW (1/15/2008)
January 16, 2008 at 9:02 pm
Wayne West (1/15/2008)
January 16, 2008 at 9:00 pm
Good luck with that... does TeraData use the same date functions as T-SQL?
January 16, 2008 at 8:53 pm
Hey Kevin Boles! Here's your chance, buddy... show us what you've got! 😉
January 16, 2008 at 8:49 pm
The error occurs because a variable can contain only one value... the unions return more than 1 value.
The option of using a table variable is good.
January 16, 2008 at 8:43 pm
Ummm.... wanna tell us what your mistake was, please?
January 16, 2008 at 8:14 pm
Why are you getting deadlock timeout errors? Because when a deadlock occurs, there's always a victim...
There really way to much to explain about deadlocks here... you really need to...
January 16, 2008 at 7:44 pm
The folks that gave those types of answers didn't help?
January 16, 2008 at 7:32 pm
Johan Kempe (1/16/2008)
Well that post was a lot of talk and nothing of interest.. just a notice of the obvious, disappointing read from an usually interesting writer.
Heh... it's an "editorial"......
January 16, 2008 at 5:09 pm
Thanks, Matt... you just saved me from having to breakout the Tally table "porkchops"! 😛
January 16, 2008 at 5:00 pm
Tobi White (1/11/2008)
January 16, 2008 at 4:58 pm
TheSQLGuru (1/11/2008)
1) It has been my experience that queries are almost NEVER as optimized as my clients think they are.
Spot on, Kevin...
January 16, 2008 at 4:41 pm
I consider myself to be one of the best around at sql server perf tuning and this product will take me to the next level due to some of the...
January 16, 2008 at 4:34 pm
Viewing 15 posts - 52,846 through 52,860 (of 59,064 total)