How to get Employee absent details ?

Question

Hi I have one employee table and Employee attendance table how to display absent employee details current date ? and also display between two date absent send Employee Details Pls post your answeer thanking you... venkat

Upendra Pratap Shahi · Answer

Hello Venkat Use updatede query or post your tables snap.

Rajkiran Swain · Answer

something wrong in your Query . just snap all the table and post here I will explain you how to do it ... Thanks Rajkiran

Upendra Pratap Shahi · Answer

Try this query with your DB- select wf.WorkforceIdwf.FirstNamev.VendorNamev.VendorCodeconvert(varchar(20)wa.AttendanceDate120) as AttendanceDatewf.Mobilebu.BUNamepr.ProjName from workforce_attendance as wa inner join mstr_workforce as wf on wa.WorkforceID=wf.WorkforceId inner join mstr_vendor as v on wf.VendorCode=v.VendorCode inner join mstr_businessunit as bu on wf.BUnit=bu.BUCode inner join mstr_project as pr on wf.Project=pr.ProjCode where not EXISTS (select * from workforce_attendance where DATEADD(D 0 DATEDIFF(D 0AttendanceDate)) Between '2015-06-06' and '2015-06-08' ) group by wf.FirstNamev.VendorNamev.VendorCodewf.Mobilebu.BUNamepr.ProjNamewf.WorkforceIdwa.AttendanceDate order by wa.AttendanceDate

Venkat Govind · Answer

this am using not showing result select wf.WorkforceIdwf.FirstNamev.VendorNamev.VendorCodeconvert(varchar(20)wa.AttendanceDate120) as AttendanceDatewf.Mobilebu.BUNamepr.ProjName from workforce_attendance as wa inner join mstr_workforce as wf on wa.WorkforceID=wf.WorkforceId inner join mstr_vendor as v on wf.VendorCode=v.VendorCode inner join mstr_businessunit as bu on wf.BUnit=bu.BUCode inner join mstr_project as pr on wf.Project=pr.ProjCode where not exists (select WorkforceId from workforce_attendance where AttendanceDate Between '2015/06/08' and '2015/06/08' ) group by wf.FirstNamev.VendorNamev.VendorCodewf.Mobilebu.BUNamepr.ProjNamewf.WorkforceIdwa.AttendanceDate

Upendra Pratap Shahi · Answer

It seems like date is not pass accordingly. Kindly pass your date in 'yyyy-MM-dd' format ...may be this work for you.

Venkat Govind · Answer

Hi Am using below query exits working but not display any records not exits . pls help me i am missing? select wf.WorkforceIdwf.FirstNamev.VendorNamev.VendorCodeconvert(varchar(20)wa.AttendanceDate120) as AttendanceDatewf.Mobilebu.BUNamepr.ProjName from workforce_attendance as wa inner join mstr_workforce as wf on wa.WorkforceID=wf.WorkforceId inner join mstr_vendor as v on wf.VendorCode=v.VendorCode inner join mstr_businessunit as bu on wf.BUnit=bu.BUCode inner join mstr_project as pr on wf.Project=pr.ProjCode where not EXISTS (select * from workforce_attendance where DATEADD(D 0 DATEDIFF(D 0AttendanceDate)) Between '06/01/2015' and '06/08/2015' ) group by wf.FirstNamev.VendorNamev.VendorCodewf.Mobilebu.BUNamepr.ProjNamewf.WorkforceIdwa.AttendanceDate order by wa.AttendanceDate

Upendra Pratap Shahi · Answer

select emp.id emp.name eatd. attandace_statuseatd.attandance_date from dbo.employee emp with(nolock) inner join dbo.employeeattandance eatd with(nolock) on emp.id=eatd.id where eatd.attandance_date='2015-06-08' select emp.id emp.name eatd. attandace_statuseatd.attandance_date from dbo.employee emp with(nolock) inner join dbo.employeeattandance eatd with(nolock) on emp.id=eatd.id where eatd.attandance_date between '2015-06-06' and '2015-06-08'