MSSQL Get Week number of Date : DATEPART

Try this, you will get the weeknumber for any date.

      SELECT  ( DATEPART(wk, '02-02-2008') )