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  



Popular posts from this blog

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report