table to hold weeks in the year 1

[lymi6977]

Can someone tell me the syntax to create a SQL table that would calculate weeks in a year, using Saturday as the week ending date?

Example of data in proposed table:

Week_num Week_end_date
01 01/08/2005
02 01/15/2005
03 01/22/2005
... and so on

Thanks.
Sheila

 

[JohnDTampaBay]

Here's one method. Good luck!

CREATE TABLE #Dates (
	Week_Num	int,
	Week_End_Date	datetime
			)

DECLARE @cntr int
SET @cntr = 0

WHILE @cntr <= 52
BEGIN
	INSERT INTO #Dates
	SELECT @cntr, DateAdd(week, @cntr, '01-08-2005')
	
	SET @cntr = @cntr + 1
END

SELECT * FROM #Dates

DROP TABLE #Dates

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)