Viewing 15 posts - 2,071 through 2,085 (of 4,081 total)
You're welcome. Best of luck to you, Glen.
October 28, 2009 at 9:52 pm
I didn't go there either, Jason.
October 28, 2009 at 9:46 pm
I'm a picker... I'm a grinner...
I use CURSORs... I'm a sinner.... 😉
October 28, 2009 at 9:18 pm
If you attempt to update a record from a subquery expression that returns multiple rows, you get an error, as you would expect.
The situation you are describing here is one...
October 28, 2009 at 9:11 pm
Grrrrrrrrrrr.... I can't get my mind back on work. Oldies tunes keep running through my head.
Some people call me the SQL Cowboy.
Some people call me the...
October 28, 2009 at 6:46 pm
Gail, can I get your autograph if I buy a copy? (I'm buying one anyway, but hey.)
Come to think of it, I need to get Grant's too. ...
October 28, 2009 at 5:54 pm
Your input is always welcome, Emperor Paulpatine. Your solution is cool. I even like the use of SQL_VARIANT. The execution plan also looks sweet, although...
October 28, 2009 at 5:35 pm
Roy: I would advise against it, yes.
Everyone else: FOR PITY'S SAKE PEOPLE, TAKE CARE OF YOURSELVES.
We'll be dropping like flies if this...
October 28, 2009 at 3:23 pm
Add alcohol and we can all watch Roy party like a rock star... or go into a coma.
October 28, 2009 at 3:12 pm
Really glad to hear you're okay, Roy. I hope everyone else is going to be alright. Dang, need to generate more good vibes in the...
October 28, 2009 at 1:23 pm
Thanks for the feedback, Jason. I'm going to test them at larger volumes if Wayne doesn't, but that will probably have to wait until after next week.
October 28, 2009 at 11:58 am
Hey Jason, better go look at that thread again.
I stumbled past what looks to be a much cleaner solution from Peter Brinkhaus. We're just...
October 28, 2009 at 10:21 am
You're welcome, Wayne. Please let us know which you finally go with and why. If one is significantly faster than the other, I'd like to...
October 28, 2009 at 7:10 am
DOH!!
Peter, I've been using Cross-Joins to expand tables forever and it never occurred to me last night. I think that your solution has serious merit and that Wayne...
October 28, 2009 at 6:32 am
It's a black hole of suckishness... beyond the event horizon, even.
October 27, 2009 at 9:49 pm
Viewing 15 posts - 2,071 through 2,085 (of 4,081 total)