One of the most important uses of CTEs is to write recursive queries. In fact, CTEs provide the only means to write recursive queries. As I noted last week , there are several excellent CTE examples, including recursive CTE examples, in Books Online .
