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)  

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...