Common table expressions are a more readable version of a derived table. CTE's can be created once then used multiple times in a query or script. CTEs have the ability to define a recursive query which allows a recursive entity to be enumerated without the need for recursive stored procedures. This videos shows you how to utilize a common table expression to update data.