Now this is something neat. if you use many subset of data and subquery, your performance may hit. Select something,Increase something by 1,and so on. Now sql server does support cte, kind like a temporary table can be referenced on your query but must...