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.WorkforceId,wf.FirstName,v.VendorName,v.VendorCode,convert(varchar(20),wa.AttendanceDate,120) as AttendanceDate,wf.Mobile,bu.BUName,pr.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, 0,AttendanceDate)) Between '2015-06-06' and '2015-06-08' ) group by wf.FirstName,v.VendorName,v.VendorCode,wf.Mobile,bu.BUName,pr.ProjName,wf.WorkforceId,wa.AttendanceDate order by wa.AttendanceDate

Venkat Govind · Answer

this am using not showing result select wf.WorkforceId,wf.FirstName,v.VendorName,v.VendorCode,convert(varchar(20),wa.AttendanceDate,120) as AttendanceDate,wf.Mobile,bu.BUName,pr.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.FirstName,v.VendorName,v.VendorCode,wf.Mobile,bu.BUName,pr.ProjName,wf.WorkforceId,wa.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.WorkforceId,wf.FirstName,v.VendorName,v.VendorCode,convert(varchar(20),wa.AttendanceDate,120) as AttendanceDate,wf.Mobile,bu.BUName,pr.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, 0,AttendanceDate)) Between '06/01/2015' and '06/08/2015' ) group by wf.FirstName,v.VendorName,v.VendorCode,wf.Mobile,bu.BUName,pr.ProjName,wf.WorkforceId,wa.AttendanceDate order by wa.AttendanceDate

Upendra Pratap Shahi · Answer

select emp.id, emp.name ,eatd. attandace_status,eatd.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_status,eatd.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'

How to get Employee absent details ?

Answers (7)