There are many great uses for CTE, my only issue is performance. I see a lot of junior developers use them when an “exists” or temp table might be a more effective use. That make sense? Enjoyed reading the article
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.