I have a table of valid Calendar Days . I would like to pass a date, and arrive at a valid Calendar Day based on my calendar below.
For example. I will pass the Calendar Day 09/03/2021. Then I would like get the 10th valid Calendar Day from 09/03/2021, which includes 09/03/2021. The 10th valid Calendar Day from 09/03/2021 should be 09/17/2021.
I gather I could use either a CURSOR or WHILE loop. What would be the best way to code this in TSQL?