Common Table Expressions (CTEs) have been a feature of SQL Server since 2005. It is an under utilized feature mostly because you can NOT use them and write efficient code. However, understanding what they can do, what they're good at, and what they're not good at will add to any developer's tool belt. CTEs are a lot like views, only less rigid. They can also reference themselves and as will be shown, can be used for recursive calls.