Using CTE(Common Table Expression) in Sql Server 2005

Here is some links for the CTE(Common Table Expression)
(1) Recursive Queries Using Common Table Expressions
 
(2) Common Table Expressions (CTE) in SQL Server 2005

(3) SQL Server 2005 Common Table

Examples
(1) Peter Larsson : Simple Fibonacci calculation

(2) Selecting list of month numbers between two dates