I feel like I've been stuck in sql purgatory, just barely knowing enough to get by. I'm really hoping to make the leap to a real developer. I welcome any recommendations.
Any code you write is a recommendation from you to the next developer to work on the same system. Do the best you can in the time you've been given.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw
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 ModenExploring Recursive CTEs by Example Dwain Camps