jsayerweb (1/29/2014)
...Hope that makes sense and my above code works...
Did you test it? I was planning to work on your problem for you over lunch but the sample data script still doesn't work!
Open a new query window and change database context to TempDB. Run your script and see what happens. Drop objects created in TempDB by your script when you're done.
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