Jason-299789 (1/8/2013)

---

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]'