0

Please login or register to vote for this query.

(click on this box to dismiss)

for Tall Jeff

Q&A for SharePoint enthusiasts

-- Upvotes/Downvotes per month
-- for Tall Jeff

select
  datepart(year, CreationDate) Year,
  datepart(month, CreationDate) Month,
  count(*) Count
from PostHistory where PostHistoryTypeId in (4,5,6,7,8,9)
group by datepart(year, CreationDate), datepart(month, CreationDate)
order by datepart(year, CreationDate), datepart(month, CreationDate)

fork query

created sep 27 11 emmettnicholas