0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, etymologists, and serious English language enthusiasts

select dateadd(week, datediff(week, 0, t.CreationDate), 0) wk, count(*)
from ReviewTasks t
where ReviewTaskTypeId=2
and ReviewTaskStateId=3
and t.CreationDate < dateadd(week, datediff(week, 0, getdate()), 0)-1
group by dateadd(week, datediff(week, 0, t.CreationDate), 0)
order by dateadd(week, datediff(week, 0, t.CreationDate), 0)

fork query

edited sep 20 15 Nathan Tuggy

created jun 4 14 anonymous