1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT DISTINCT
    52 * DATEPART(year, v.CreationDate) + DATEPART(week, v.CreationDate)
  FROM
    Votes AS v
  WHERE
    v.VoteTypeId IN (2, 3) -- UpMod, DownMod

view current version

edited jul 30 15

created jul 30 15 senshin