Relative Populatrity of ASP.NET Web Forms and MVC Over Time

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query shows the number of ASP.NET, WebForms and ASP.NET MVC posts month by month over time

Stack Overflow

Q&A for programmers

-- Relative Populatrity of ASP.NET Web Forms and MVC Over Time
-- This query shows the number of ASP.NET, WebForms and ASP.NET MVC posts month by month over time
select 
  CONVERT(VARCHAR,DATEPART(yy, p.CreationDate)) + RIGHT('0'+ CONVERT(VARCHAR,DATEPART(m, p.CreationDate)),2) as [Month],
  SUM(CASE WHEN t.tagname like '%asp.net%' THEN 1 ELSE 0 END) as AspNetPosts, 
  SUM(CASE WHEN t.tagname like '%webforms%' THEN 1 ELSE 0 END) as WebFormsPosts, 
  SUM(CASE WHEN t.tagname like '%asp.net-mvc%' THEN 1 ELSE 0 END) as MvcPosts
from posts p
inner join posttags pt on pt.postid = p.id
join tags t on pt.tagid = t.id 
group by DATEPART(yy, p.CreationDate),
  DATEPART(m, p.CreationDate)
order by 1

Enter Parameters

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