Thursday, October 22, 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  



Ensure that this project has Microsoft.Bcl.Build installed and packages.config is located next to the project file

In my Xamarin form application their was dependency Restclient on Microsoft.Bcl.Build Microsoft.Bcl. i just remove all using nuget and ...