SQL Server works better when you try to handle things like this with tables.

perhaps something like this would work better for you:

DECLARE @Weeks TABLE (

Week INT IDENTITY,

StartDate DATE,

EndDate DATE

)

DECLARE @NumWeeks...