Difference between Common Table Expression Vs Temp Table Vs Table Variable

This article will explain the details of Common Table Expression , Temp Table and Table Variable

http://www.dotnet-tricks.com/Tutorial/sqlserver/X517150913-Difference-between-CTE-and-Temp-Table-and-Table-Variable.html

Other Useful Link :

http://msdn.microsoft.com/en-us/library/ms175972.aspx

http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER-2008