Common Table Expressions

http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-3.aspx