I didn't realize that this was a recent article as I had just stumbled onto it over the weekend. It gave me an idea on a troublesome query that I was working on last Fri. I abandoned my convoluted subquery and re-wrote it using 2 CTE's as in your example. I produced the results that I wanted within 10 minutes. Thanks for the great article.
That's fantastic feedback, thanks so much Alan, good to hear it helped.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.