Close reviews by week

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select dateadd(week, datediff(week, 0, r.CreationDate), 0) wk, count(*)
from ReviewTaskResults r
join ReviewTasks t on t.Id=r.ReviewTaskId
where ReviewTaskTypeId=2
and ReviewTaskResultTypeId<>1
and r.CreationDate < dateadd(week, datediff(week, 0, getdate()), 0)-1
group by dateadd(week, datediff(week, 0, r.CreationDate), 0)
order by dateadd(week, datediff(week, 0, r.CreationDate), 0)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results