Understanding PIVOT and UNPIVOT
(Vinod Kumar) There are tons and tons of T-SQL: features that have been added into SQL Server that any developer would like to capitalize. In this article we will look at one such feature that has been under the dream requirement which SQL Server lacked when compared to its small brother Access (TRANSFORM Feature). The feature I am talking is PIVOT. With the release of SQL Server 2005 this frustration of this missing feature will come to an end.

Read More >>