Browse by Tags

All Tags » dynamic crosstab » sql server (RSS)
27 August 2008 13:31

Dynamic PIVOT in SQL Server 2005

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...
Posted by Madhivanan | with no comments
Filed under: , , ,
27 August 2007 16:23

Dynamic Crosstab with multiple PIVOT Columns

Jeff Smith in his weblog showed how to generate Crosstab reports using a stored procedure. It works only for one PIVOT Column.I had a requirement to generate crosstab reports with more than one pivot column. So I used the same approach he used and modified...
Posted by Madhivanan | 2 comment(s)
Filed under: , , ,