Saw your update after you posted mine. The problem with populating a table is you don't know how many days to populate it with. It seems you would have to...

That doesn't work, it gives the same result if you add a day or weekday.These two sets of statements return the same result.

select dateadd(weekday,1, getdate())

select dateadd(weekday,2, getdate())

select dateadd(weekday,3, getdate())

select dateadd(weekday,4,...

I agree with the principle of avoiding cursors and row based operations. However I'm trying to do this same type of calculation, but given a start date, add a number...