essentialsql.com
Introduction to Common Table Expressions (CTE's) - Essential SQL
Common Table Expressions or CTE’s for short are used within SQL Server to simplify complex joins and subqueries. Recursive CTE's can solve complex queries.