Skip to content
loading...

re: SQL 201: Why you should use SQL CTEs VIEW POST

FULL DISCUSSION
 

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.

code of conduct - report abuse