https://www.dotnetzone.gr:443/cs/blogs/dotnetrules/archive/2011/11/20/using-common-table-expressions-in-sql-server.aspxIn this post I would like to talk about Common Table Expressions or CTE . I know there are samples of how to use CTE in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.CTEs were introduced in SQLelCommunityServer 2.1 SP3 (Build: 20423.1)