• I see...

    Create Table ##DateTable

    (

    Lastweek Int

    ,Lastweek1 Int

    ,Lastweek2 Int

    )

    Insert into ##DateTable(Lastweek,Lastweek1,Lastweek2)

    Values (DATEPART(WW,GETDATE()) - 1 ,DATEPART(WW,GETDATE()) - 2, DATEPART(WW,GETDATE()) - 3 )

    Select * from ##DateTable

    Thanks