Nice article about CTE(Common Table Expression)

 reference url:

http://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/