Skip to main content

Posts

Showing posts from October, 2015

SQL Table Row Data show in column data

SELECT * FROM (SELECT CAST(mlblmsg AS varchar(max)) AS mlblmsg,clblcode FROM warninglabels) t PIVOT (MAX(mlblmsg) FOR clblcode IN ([0001],[0002],[003],[0004],[0005],[0006]))p