Monday, February 24, 2014

SQL get last 6 month data

Not only 6 month you can get data as you want.

 SELECT *  
 From PIS.dbo.PIS_tblEmployeeGenInfo  
 WHERE dtJoiningDate > DATEADD(m, -6, current_timestamp)  

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