I use CTEs quite a lot.. cause when you are scrapping report from DWH, you won't be having write access to different database.. so you can't create tables to store data.. much easier option is CTE than subquery when you are extracting data from multiple tables and joining together.. if you use subquery, it gets very ugly and hell lot of difficult to do any changes afterwards.. hence I love CTEs
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I use CTEs quite a lot.. cause when you are scrapping report from DWH, you won't be having write access to different database.. so you can't create tables to store data.. much easier option is CTE than subquery when you are extracting data from multiple tables and joining together.. if you use subquery, it gets very ugly and hell lot of difficult to do any changes afterwards.. hence I love CTEs