0

Please login or register to vote for this query.

(click on this box to dismiss)

for Tall Jeff

Q&A for SharePoint enthusiasts

-- Answers per month
-- for Tall Jeff

select
  datepart(year, CreationDate) Year,
  datepart(month, CreationDate) Month,
  count(*) Count
from Posts where PostTypeId = 2
group by datepart(year, CreationDate), datepart(month, CreationDate)
order by datepart(year, CreationDate), datepart(month, CreationDate)

fork query

created sep 27 11 emmettnicholas