Thursday, February 6, 2014

sql datetime in join condition

In sql join on date or other query we fall common problem of time span. we can easily remove that to convert the date in to var-char & date format code 106 in sql.

 LEFT JOIN Payroll_tblEmployeeLeave ON PIS.dbo.PIS_tblEmployeeGenInfo.GEmployeeGenInfoID=Payroll_tblEmployeeLeave.GEmployeeGenInfoID   
 and Convert(varchar(11) ,Payroll_tblEmployeeLeave.LeaveDate,106 )=''' + Convert(varchar(11),@OfficeLeaveDate,106 ) + '''  

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.