SQLServerCentral » Latest topics
Where to use ISNULL to convert NULL in PIVOT result set
Hi,
I can't figure out where to use ISNULL (or COALESCE) to convert NULL values in the pivot result set to 0. I need to do this because I will be using UNPIVOT to transform the data and it discards any rows that contained NULL.
I can't figure out where to use ISNULL (or COALESCE) to convert NULL values in the pivot result set to 0. I need to do this because I will be using UNPIVOT to transform the data and it discards any rows that contained NULL.
No comments:
Post a Comment