Browse by Tags

All Tags » PIVOT (RSS)

Splitting delimited data to columns - Set based approach

In this post splitting-csv-to-columns I showed how to split delimited data into multiple columns Simon in his post Set-based-splitting-of-delimited-strings-to-columns showed how to use that in a set based approach which would work on a set of data.In...
Posted by Madhivanan | with no comments
Filed under: , , , ,

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...