Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone please help me on the below Scenario?
1. I have a master calendar with all dates in a year 2014 as table Calendar.
2. And also i have another calender derived form Master calender as table Calendar 1.
3.I also have a another table loaded from excel spreadsheet as table Holidays 2014.
4.And also have last table named Working Days.
(I got this by comparing Calendar and Holidays 2014) used where not Exists function.
All i need is to re-Create table 4(Working Days) by connecting table 1(Calendar) and 3(Holidays 2014).