Tags activity 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

DECLARE @TagName NVarChar(50) = '##TagName##'



SELECT COUNT(Id), Year(CreationDate), Month(CreationDate) FROM Posts
WHERE PostTypeId = 1
AND Tags LIKE '%<' + @TagName+'>%'
GROUP BY Year(CreationDate), Month(CreationDate)
ORDER BY Year(CreationDate), Month(CreationDate)

Enter Parameters

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