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.

Eric · Accepted Answer · 2009-08-18T17:31:58.863

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

edited Aug 18 '09 at 17:31

answered Aug 18 '09 at 17:26

Eric

Hi Eric, I only need results: THIS WEEK NUMBER. It's correct syntax but the results are: WEEK NUMBER DATA for the whole year. – Yves Aug 18 '09 at 17:28
Eric, I understand your logic; you are doing hard code. I need to use: GETDATE() – Yves Aug 18 '09 at 17:30
@Yonita: I changed the queries to only bring back the week number. Of course, this is really superfluous and too much overhead if you just need the week number, *unless* you're validating to make sure that week is in your date table. – Eric Aug 18 '09 at 17:31
you are right - I am doing validation. Can you help me on this? – Yves Aug 18 '09 at 17:32

score 0 · Answer 2 · answered Aug 18 '09 at 17:27

0

This looks good to me.

answered Aug 18 '09 at 17:27

tw39124

2 Answers2