Hi, I have implemented as per below query,If Employee is absent on Saturday and Monday the weeklyoff should be counted as Absent. I have passed the process date parameter in place of static date. SELECT A.EmpCode,A.AttDate As Sundate FROM Attendance_Details A INNER JOIN (SELECT A.Empcode,A.AttDate As SatDate,A.AttStatus As SatStatus FROM Attendance_Details A INNER JOIN (SELECT EmpCode,AttDate As MonDate,AttStatus As MonStatus FROM Attendance_Details WHERE AttDate='2021-06-07' AND DATENAME(WEEKDAY, '2021-06-07') = 'Monday' and AttStatus IN ('A','HL'))T ON T.EmpCode=A.EmpCode WHERE DATENAME(WEEKDAY, DATEADD(day,-2,'2021-06-07')) = 'Saturday' AND AttStatus IN ('A') AND AttDate=DATEADD(day,-2,'2021-06-07'))T1 ON A.EmpCode=T1.EmpCode AND DATENAME(WEEKDAY, DATEADD(day,-1,'2021-06-07')) = 'Sunday' AND AttStatus NOT IN('AL','SL','PL','ML','FL') AND AttDate=DATEADD(day,-1,'2021-06-07') Please help to improve the above query... Thanks & Regards Mohammad Salmani

Thanks Richard

I am having the below data in Attendance Table EmpCode AttMonth AttYear AttDate ShiftCode AttStatus 1 6 2021 2021-06-01 00:00:00.000 1001 P 1 6 2021 2021-06-02 00:00:00.000 1001 P 1 6 2021 2021-06-03 00:00:00.000 1001 P 1 6 2021 2021-06-04 00:00:00.000 1001 P 1 6 2021 2021-06-05 00:00:00.000 1002 A 1 6 2021 2021-06-06 00:00:00.000 1009 WO 1 6 2021 2021-06-07 00:00:00.000 1001 A 1 6 2021 2021-06-08 00:00:00.000 1001 P 1 6 2021 2021-06-09 00:00:00.000 1001 P I need to update 'WO' as 'A' while processing attendance please help for the above.

I am getting the below errors. Uncaught ReferenceError: bobj is not defined GEThttp://localhost:82/aspnet_client/system_web/2_0_50727/crystalreportviewers13/js/crviewer/crv.js GEThttp://localhost:82/aspnet_client/system_web/2_0_50727/crystalreportviewers13/js/crviewer/crv.js tried many solution available on google Thanks & Regards Mohammad Salmani

Hi, Failed to open crystal report in browser in ASP.Net and debugging shows some reference error. Tried many solution but failed. Thanks & Kind Regards Mohammad Salmani

Hi,

I am looking a sandwich query for my attendance module, If the employee is absent on Saturday and Monday then sunday will be calculate as Absent the same has to be case of holidays.

The attendance table structure in SQL 2005 as per below.

EmpCode
EmpShift
AttDate
AttStatus
.
.

Please Advice/provide some solution for the above.

Thanks & Kind Regards
Mohammad Salmani