My OperaCross-Tab or PIVOT in SQL-Server2005
Wednesday, October 31, 2007 8:22:55 AM
PIVOT
With the new PIVOT operator in SQL Server 2005, the CASE statement and GROUP BY statements are no longer necessary. (Every PIVOT query involves an aggregation of some type, so you can omit the GROUP BY statement.) The PIVOT operator provides the same functionality that we tried to achieve with the CASE statement query, but you can achieve it through less code.
Please refer
http://balavardhanreddy.over-blog.com/article-28732300.html
With the new PIVOT operator in SQL Server 2005, the CASE statement and GROUP BY statements are no longer necessary. (Every PIVOT query involves an aggregation of some type, so you can omit the GROUP BY statement.) The PIVOT operator provides the same functionality that we tried to achieve with the CASE statement query, but you can achieve it through less code.
Please refer
http://balavardhanreddy.over-blog.com/article-28732300.html
Unregistered user # Saturday, August 8, 2009 12:52:44 PM