Test for Language Percentages over Time

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 Name, year(p.CreationDate) as Year, month(p.CreationDate) as Month, count(*) as Posts, p.CommentCount as CommentCount, p.Id as ID
  from Posts p cross join (values
    ('C')
  ) as Language(Name)
  where (SUBSTRING(p.Body,0,CHARINDEX(char(10),p.Body)) like '%[ >,\[ ]'+Name+'[, :\]]%')
  group by Name, year(p.CreationDate), month(p.CreationDate), p.CommentCount, p.Id

Enter Parameters

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