Home Forums SQL Server 2005 T-SQL (SS2K5) Column type conflict in Unpivot list RE: Column type conflict in Unpivot list
proof
SSC Journeyman
Points: 91
More actions
March 24, 2011 at 1:13 pm
#1303190
All columns have to be of the same data type AND length. That was the only way I got mine to work, by converting them all to varchar(50).
If I had some columns varchar(3) AND some varchar(50) it crapped out.