Tag Archives: UNPIVOT

The type of column “xxx” conflicts with the type of other columns specified in the UNPIVOT list.

When pivoting data in SQL Server, all columns must be of same time, otherwise you will get this error. You might get this error if you have imperfect case statement or one column is of integer type while the other … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment