How to get Employee absent details ?

Venkat Govind

11y1kLearn iOS Programming

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Hello Venkat,

Use updatede query or post your tables snap.
Rajkiran Swain11y ago
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 Shahi11y ago
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 Govind11y ago
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 Shahi11y ago
It seems like date is not pass accordingly.
Kindly pass your date in 'yyyy-MM-dd' format ...may be this work for you.
Venkat Govind11y ago
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 Shahi11y ago
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'