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

select
  datepart(year, CreationDate) Year,
  datepart(month, CreationDate) Month,
  count(*) Count
from Votes where VoteTypeId in (2,3)
group by datepart(year, CreationDate), datepart(month, CreationDate)
order by datepart(year, CreationDate), datepart(month, CreationDate)

fork query

created sep 27 11 emmettnicholas