I hadn't considered that CTEs are also a nice way to alias sub datasets in general cases. Thanks. I can already see a few of my reporting queries that would benefit from being organized in this way.
I find myself only reaching for CTEs when I'm using them recursively.
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 hadn't considered that CTEs are also a nice way to alias sub datasets in general cases. Thanks. I can already see a few of my reporting queries that would benefit from being organized in this way.
I find myself only reaching for CTEs when I'm using them recursively.