I want to set start of week and end of week date in different variable like below..

If i want to do for 12 weeks, for that i need to write 12 statements like below so thought to put in loop

and thought to assign?

declare @Wkstr1 date, @Wkstr2 date,@Wkstr3 date,@Wkstr4 date,@Wkstr5 date,@Wkstr6 date,@Wkstr7 date,@Wkstr8 date

declare @Wkend1 date,@Wkend2 date,@Wkend3 date,@Wkend4 date,@Wkend5 date,@Wkend6 date,@Wkend7 date,@Wkend8 date

set @Wkstr1=dateadd(Wk, datediff(Wk, 6, getdate()), 0)

set @Wkend1= dateadd(Wk, datediff(Wk, 6, getdate()), 6)

select @Wkstr1

select @Wkend1

set @Wkstr2=dateadd(Wk, datediff(Wk, 6, getdate()), -7)

set @Wkend2= dateadd(Wk, datediff(Wk, 6, getdate()), -1)

select @Wkstr2

select @Wkend2

set @Wkstr3=dateadd(Wk, datediff(Wk, 6, getdate()), -14)

set @Wkend3= dateadd(Wk, datediff(Wk, 6, getdate()), -8)

select @Wkstr3

select @Wkend3

set @Wkstr4=dateadd(Wk, datediff(Wk, 6, getdate()), -21)

set @Wkend4= dateadd(Wk, datediff(Wk, 6, getdate()), -15)

select @Wkstr4

select @Wkend4

set @Wkstr5=dateadd(Wk, datediff(Wk, 6, getdate()), -28)

set @Wkend5= dateadd(Wk, datediff(Wk, 6, getdate()), -22)

select @Wkstr5

select @Wkend5