Common Table Expressions (CTE) in SQL Server 2005

http://www.4guysfromrolla.com/webtech/071906-1.shtml