Viewing 15 posts - 1,996 through 2,010 (of 4,080 total)
It's a handy function, and a well written article. But, although I much prefer CTEs to subqueries, recursive CTEs are notoriously slow for this type of problem. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 20, 2009 at 6:54 am
Even a cross-tab is going to do an aggregation. I use MAX() as the aggregation function.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 19, 2009 at 6:10 pm
Any fool can write
Haiku in English.
All he does is stop at sev
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 18, 2009 at 6:56 pm
I know 😉
But you could spend your time helping someone else who also needs it and would appreciate it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 18, 2009 at 10:40 am
Lynn,
He's a flamer. Just walk away. Unsubscribe from that thread, and let him take his attitude elsewhere.
Chad,
Thanks. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 18, 2009 at 10:32 am
I've always wondered about the sequence of titles. It seems like you should be crazy BEFORE you are committed. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 17, 2009 at 4:17 pm
Lynn!! You're back !! 🙂
How was the desert?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 17, 2009 at 2:42 pm
GilaMonster (11/17/2009)
Lynn Pettis (11/17/2009)
ARRRRGGGGGG!!!!Anything in particular?
Overwhelming relational angst?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 17, 2009 at 12:45 pm
Have a nice trek, Lynn. Mind the shai-hulud.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 17, 2009 at 9:40 am
Did somebody say "googoo peanut clusters" ??

__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 16, 2009 at 2:22 pm
I was shocked to see renewed activity in this thread. I thought it was ancient history.
Don't worry, Stuart. There is no blacklist, and never...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 16, 2009 at 9:49 am
GilaMonster (11/16/2009)
Aaahhhhhh!!!http://www.sqlservercentral.com/Forums/Topic817076-146-1.aspx
Spoon feeding?
Gail,
Try to... contain.... fist... of death!!
: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
November 16, 2009 at 6:02 am
If I may add a few comments:
1. Lutz knows SQL. He is humble enough to admit that he is still capable of learning more about it,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 15, 2009 at 11:25 am
Looks like pure spam to me. I'd vote to zap that account and remove all messages originating from it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 14, 2009 at 9:13 am
Thank you for posting sample data and code. Unfortunately, your code sample is incomplete and correct. You dont' define or provide values for five local variables,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 14, 2009 at 7:25 am
Viewing 15 posts - 1,996 through 2,010 (of 4,080 total)