Jeff Moden (5/27/2012)
RBarryYoung (5/26/2012)
Jeff Moden (5/26/2012)
You mean just as a separate post or here or did you have something else in mind, Barry?Right, a separate post, with a data set (million rows, of course) and a formal statement of the challenge ("fastest execution time to produce result set like this ...".
I actually have a fair start on the data set...
Got it. I'll see what i can do. Thanks, Barry.
Wow... talking about a forgotten promise... my apologies, Barry.
That, notwithstanding, please see the following article which also has a million row "clean" hierarchy generator.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
This next one is part of the same series (2 articles in the series) and provides an alternate to all of the currently known hierarchical structures.
http://www.sqlservercentral.com/articles/T-SQL/94570/
--Jeff Moden
Change is inevitable... Change for the better is not.