How is your favourite language/tag doing on SO?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the trend for your favourite tag

Amateur Radio

Q&A for amateur radio enthusiasts

-- How many posts per month for a tag?
-- Shows the trend for your favourite tag

DECLARE @TagName varchar(255) = '##TagName##';

DECLARE @PostCountByMonth TABLE
(
  [date] datetime,
  [count] int,
  UNIQUE CLUSTERED ([date])
);

INSERT INTO @PostCountByMonth
SELECT dateadd(month, DATEDIFF(month, '', p.CreationDate), '') [date], count(*) [count]
FROM Posts p
WHERE p.Tags LIKE '%<##TagName##>%'
GROUP BY DATEDIFF(month, '', p.CreationDate)
ORDER BY DATEDIFF(month, '', p.CreationDate);

SELECT datepart(year, p1.[date]) [year], datepart(month, p1.[date]) [month], sum(p2.[count]) [trend]
FROM @PostCountByMonth p1 INNER JOIN @PostCountByMonth p2
  ON p1.[date] >= p2.[date]
GROUP BY p1.[date]

Enter Parameters

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