First two examples (in the suggested article below) exhibit non recursive common table expressions (CTE) but CTE is motsly used for recursion.

WITH common_table_expression (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms175972(v=sql.105).aspx