Mitesh Oswal (9/4/2012)
Farooq,Can you please verify the below code. Looks better performance...
Very interesting. Can you post the test script which you used for the comparison?
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