Query for Holidays as per Attendance Table

Basit Khan

7y895.NET

Hi,

I have Holiday Master table given below.

Hold_No numeric

Hold_From Date

Hold_To Date

Hold_Type varchar(50)

I have Attendance Table is given below.

Atn_No Numeric

Atn_Date Date

Atn_EmpNo numeric

Atn_Type Varchar(50)

What want is check in Attendance if Type is "OD" then check in Holiday Master how many days are OD as per Holidays in Attendance.

as per above Output No. of Holidays is 2

Thanks

Basit.

4 Replies

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

Salman Beg7y ago
Hi. You can write your query like this, Select * from Attendance at join Holiday hd on at.Hold_From=hl.Atn_Date where at.Atn_Type='OD' Thanks.
0
Puneet Kankar7y ago
i am not much understand above requirement but we join with date columns.
0
Salman Beg7y ago
Hi. But How do we join Holiday and Attendance Table. Can you please tell me what is the common column between both table. Thanks.
0
Puneet Kankar7y ago
hey please share your ouput format.for more detail for you ouput i am not much understood you requirement. Given below query is helpful for you or you want other oupput let me know.
SELECT count(*) as Total FROM   AttendanceMaster a,  HolidayMaster b where
a.Atn_Type='OD' and convert(date,a.Atn_Date,103)=   convert(date,b.Hold_From,103)
0