phani.gudmines (7/29/2014)
Hi chrisseems that you are using 1,2,3,4,5 staticly.we dont know how may rows we get as described.i have just given u a sample data.
Thanks
How many rows might you expect?
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