Jeff Smith in his weblog showed how to generate Crosstab reports using a stored procedure. I had a requirement to generate crosstab reports with more than one pivot column. So I used the same approach he used and modified his procedure as shown below CREATE procedure CrossTab ( @select varchar(2000), @PivotCol varchar(100), @Summaries ...