look up this week number?

Question

I know how to look up this week number:

(SELECT DATEPART(wk, GETDATE()))

I need to know the syntax of getting the week number compare to another table: SYNTAX:

SELECT     THISWEEK  -- WEEK NUMBER DATA
FROM       dbo.DATETABLE
WHERE THISWEEK  = (DATEPART(wk, GETDATE()))  -- THIS IS THE PART I AM NOT SURE.

Answer 1

That's the correct syntax. You have more than the necessary amount of parens, but it does no harm.

select distinct
    thisweek
from
    datetable
where
    thisweek = datepart(wk, getdate())

Is equivalent to saying:

select distinct
    thisweek
from
    datetable
where
    thisweek = 34 --8/18/09 is in the 34th week of 2009

Answer 2

This looks good to me.