Thursday, October 31, 2013

use of PIVOT operator dynamically

Yes,


Both the queries worked well. But there are two issues with the resultset.


1. Order by should be proper like January-2013, February-2013......December-2013. Currently order is April-2013, February-2013


2. I want NULL in the resultset to be shown as zero (0)


Please help with this


No comments:

Post a Comment