SET DATEFIRST 1
SET DATEFORMAT dmy


DECLARE @s DATETIME
DECLARE @i INTEGER

SET @s = '03/01/2011'
SET @i = 522

WHILE @i > 0
BEGIN
	INSERT INTO Intranet.dbo.tblWeeks
		(WeekNumber,StartDate,EndDate)
	SELECT DATEPART(WEEK,@s),@s,DATEADD(DAY,6,@s)
	
	SET @s = DATEADD(WEEK,1,@s)
	SET @i = @i - 1
END