The example holiday data:
HolidayID |
EmployeeID |
StartDate |
DaysHoliday |
1 |
1002 |
1/2/97 |
5 |
2 |
1003 |
21/2/97 |
1 |
3 |
1002 |
24/2/97 |
3 |
4 |
1004 |
1/3/97 |
4 |