HI,
i have a data set as below
Id Date count
1 2/10/16 2
2 2/1/16 1
3 5/6/16 4
I would like my result set as below
Id Date count Week Day(No Required)
1 2/10/16 1
1 2/11/16 1
2 2/01/16 1
3 5/06/16 1 Friday
3 5/09/16 1 Monday
3 5/10/16 1 Tuesday
3 5/11/16 1 Wednesday
Note: If the day of the week is Saturday or Sunday in has to skip date and select the next date. Based on the count the records should be created by increment(or adding a new record for same ID but using different date) one day(if it is Sunday or Saturday please pick following Monday as shown in example of ID 3)
Can some one please advise.
Thank You
