CTE common table expressions

Check out CTE and the logic and functionality

Sources:

Author:
Itzik Ben-Gan
Inside Microsoft® SQL Server™ 2005:
T-SQL Querying

Very helpful solution, no more any need for temp tables ? Need to check out.