Used the code given by you. Still not complete code.. at least as of now....

I get the following error

Msg 207, Level 16, State 1, Line 29

Invalid column name 'week_date'.

Msg 207, Level 16, State 1, Line 34

Invalid column name 'weeknbr'.