I understand the need to use SQL when doing SQL but a little looping wont kill ya 🙂

I'd still do something like the following

declare @i int = -7...

Hi Rookie

If you want to take the direct approach, you'll need to loop through with DATEADD( ) function

then go forward with D, 1,

and backwards with D,...