"However the last few years I find myself crunched to get work done in my work week".
Only the last few years? I've often wondered how you manage to get so much stuff done in a 5-day week, Steve. Quite remarkable. And it counts, too. I'm sure only a tiny fraction of the folk who peruse SSC and Database Weekly take the time to comment.
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