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.
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.