Viewing 15 posts - 2,071 through 2,085 (of 4,080 total)
I didn't go there either, Jason.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 28, 2009 at 9:46 pm
I'm a picker... I'm a grinner...
I use CURSORs... I'm a sinner.... 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 28, 2009 at 6:32 am
It's a black hole of suckishness... beyond the event horizon, even.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 27, 2009 at 9:49 pm
Hey, don't think I always stumble into sweet-smelling stuff. :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 27, 2009 at 7:58 pm
Viewing 15 posts - 2,071 through 2,085 (of 4,080 total)