Jay Sapani (1/26/2015)
first of all serg-52 no need to be sorry.thanks for the solution.
want a suggestion on some nice way to improve knowledge of new sql as till now i was using sql server 2000 only.
Really you have to learn a lot of new features. CTE, APPLY, XML, window functions (OVER Clause ), PIVOT/UNPIVOT... to mention a few. This site has a number of helpful Stairways, see http://www.sqlservercentral.com/articles/Stairway+Series/119933/ for example. I think you need also obtain some book by Itzik-Ben-Gan.