Steve Jones - SSC Editor (1/22/2011)
Definitely not SQL related, but my kid got his black belt today. Very proud of him.
Congrats to both of you... Well done.
-Roy
mister.magoo (1/24/2011)
Jeff Moden (1/23/2011)
Slight departure from the norm on this thread. One of our own made an absolute killing on a nasty problem. See "mister.magoo"s final code post on the following thread. It's bloody genius at work...http://www.sqlservercentral.com/Forums/Topic1049892-392-1.aspx
Well done, Magoo!
thanks for those kind words Jeff.
You should write an article about it, Magoo. It's a classic example of where "doing things all in one query" is absolutely the wrong way to go. It's also an example of where "set based" thinking merges with Row-by-Row action and, most definitely, a good example of where "It Depends" comes into play to the max.
Me? I've got these sugar plums dancing in my head and I need to experiment with what you've done. Maybe there's a way to do a MERGE with this that will blow MERGE out of the water or create a hierarchical path from an Adjacency List more quickly.
Another clever thing you've done that (IIRC) adds a bit of speed... you were able to avoid BEGIN/END in the WHILE loop.
I don't mean to make it so your head can't fit through the door but I've got to say it again... absolutely brilliant code, Magoo.
--Jeff Moden
Change is inevitable... Change for the better is not.
Roy Ernest (1/24/2011)
Steve Jones - SSC Editor (1/22/2011)
Definitely not SQL related, but my kid got his black belt today. Very proud of him.Congrats to both of you... Well done.
Speaking of "well done", nice job on the "remote meeting" article, Roy.
--Jeff Moden
Change is inevitable... Change for the better is not.
We both do kenpo karate, about 4 years for him. I've studied a few more arts, but this was a good local fit for my son. Lots of Muy Thai and Gracie jujitsu influence for our teacher.
Viewing 15 posts - 23,386 through 23,400 (of 66,805 total)
You must be logged in to reply to this topic. Login to reply