0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

select
  datepart(year, P.CreationDate) + convert(float,datepart(month, P.CreationDate))/100 monthYear,
  count(*) n
from Posts P
  join PostTags PT on P.Id = PT.PostId
  join Tags T on PT.TagId = T.Id
where T.TagName = 'wpf'
group by datepart(year, P.CreationDate) + convert(float,datepart(month, P.CreationDate))/100

select
  datepart(year, P.CreationDate) + convert(float,datepart(month, P.CreationDate))/100 monthYear,
  count(*) n
from Posts P
  join PostTags PT on P.Id = PT.PostId
  join Tags T on PT.TagId = T.Id
where T.TagName = 'wcf'
group by datepart(year, P.CreationDate) + convert(float,datepart(month, P.CreationDate))/100

fork query

edited jun 11 13

created jun 11 13 anonymous