If your sample data doesn't look anything like your real data, then you are likely to receive queries which don't work when run against your real data.
How about an update on that sample data, so that it's a little more representative of what you've really got?
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