Tuesday, July 1, 2014

Unpivot, Pivot without Aggregation

Interesting thing is if I ran one role like Sales manger it works but if I run all roles it give me error.


Msg 8167, Level 16, State 1, Line 37

The type of column "District Manager" conflicts with the type of other columns specified in the UNPIVOT list.

No comments:

Post a Comment