Browse by Tags

All Tags » T-SQL » dynamic PIVOT   (RSS)
Dynamic PIVOT in SQL Server 2005
27 August 08 12:58 PM | Madhivanan | 2 Comments   
The PIVOT operator available in SQL Server 2005 is used to generate the Cross-tab results Consider this example select * from ( select Year ( OrderDate ) as pivot_col , e . lastname , o . OrderDate FROM northwind .. Employees as e INNER JOIN northwind Read More...