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.
| Hold_No |
Hold_From |
Hold_To |
Hold_Type |
| 1 |
01-Jan-19 |
02-Jan-19 |
XYZ |
| 2 |
05-Jan-19 |
05-Jan-19 |
LMN |
| Atn_No |
Atn_Date |
Atn_EmpNo |
Atn_Type |
| 1 |
01-Jan-19 |
1 |
OD |
| 2 |
02-Jan-19 |
1 |
AB |
| 3 |
03-Jan-19 |
1 |
OD |
| 4 |
04-Jan-19 |
1 |
SL |
| 5 |
05-Jan-19 |
1 |
OD |
| 6 |
06-Jan-19 |
1 |
OD |
| 7 |
07-Jan-19 |
1 |
OD |
| 8 |
08-Jan-19 |
1 |
OD |
as per above Output No. of Holidays is 2
Thanks
Basit.