Thursday, May 8, 2014

sql row value wise count

Query:

 SELECT   COUNT(CASE WHEN DayStatusID = 1 THEN 1 END) AS A,  
             COUNT(CASE WHEN DayStatusID = 7 THEN 1 END) AS B,  
             COUNT(CASE WHEN DayStatusID = 3 THEN 1 END) AS C  
 from Payroll_tblYearMonthDayEntry  

Result:


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 ...