I am new to T-SQL , i need to to extract the date from calendar as per work day with below conditions :
- Week starts from Saturday
- There are 6 days in a week as Friday will not be counted .
Salesman-1 have a journey plan for Store-X on SATURDAY, MONDAY & WEDNESDAY , Whereas FRIDAY there will be no visit.
Workday’s are : 1 , 3 , 5 , 7 , …
Where : 1 = Saturday (Week Start) , 2 = Sunday , 3 = Monday , 4 = Tuesday ,
5 = Wednesday, 6 = Thursday , 7 = Saturday ( Friday will be skipped )
So the outcome of the query should be :
Saturday ( 07.Oct-2017 ) ,
Monday ( 09.Oct-2017 ) ,
Wednesday ( 11.Oct-2017 ) ,
Saturday ( 14.Oct-2017 )