Final Edit,

Dwain, I figured out why yours didnt work you're addind on the Julian day which is 1-365/366

I think you need to add the Week day number something like this

CREATE TABLE #Calendar

([Date] DATETIME PRIMARY KEY

,[Year] INT

,[JulWk] INT

,[WkDNo] INT

,ISO_WK AS (CAST([Year] AS CHAR(4)) + 'W' +

CAST([JulWk] AS VARCHAR(2)) + '-' +

CAST([WkDNo] AS VARCHAR(3)))

)

INSERT INTO #Calendar

SELECT [Date], [Year], [JulWk], [WkDNo]

FROM GenerateCalendar('20120101', 365*2)

SELECT * FROM #Calendar

WHERE ISO_WK LIKE '2012W26-[67]'