select dateadd(week, datediff(week, 0, c.CreationDate), 0...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select dateadd(week, datediff(week, 0, c.CreationDate), 0) wk, count(*)
from comments c
where 
 c.CreationDate < dateadd(week, datediff(week, 0, getdate()), 0)-1
group by dateadd(week, datediff(week, 0, c.CreationDate), 0)
order by dateadd(week, datediff(week, 0, c.CreationDate), 0)

Enter Parameters

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