How do I get the week number from dates in T-SQL?
Have a look at DATEPART
SELECT DATEPART(wk, GETDATE())