Lynn Pettis (4/12/2013)
The CTE and NoCTE versions are comparable on a small data set. I'd like to try them both on a million row data set and see how they compare.Perhaps this evening I will have a chance to set it up.
Heh if it's a race Lynn, I reserve the right to change shoes!!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden