rasha.adel82 (12/19/2010)
Hi ,I belive Pivot which is a new TSQL 2005 feature can do it easily
Pivot is also quite a bit slower than a good ol' fashioned crosstab. Have a look, rasha...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--Jeff Moden
Change is inevitable... Change for the better is not.