0

Please login or register to vote for this query.

(click on this box to dismiss)

A plot of upvotes on a post more than 10 days old over time. Only interesting in graph tab.

Q&A for professional and enthusiast programmers

declare @recentDaysExcluded int = 10

select
  i.VoteDate [Date],
  max(i.Upvotes) [Upvotes]
from (  
  select  
    v.CreationDate [VoteDate],
    ROW_NUMBER() OVER (ORDER BY v.CreationDate) [Upvotes]
  from 
    votes v 
  inner join 
    Posts p 
  on v.PostId=p.id 
  where 
    p.OwnerUserId=##UserId## 
    and v.VoteTypeId = 2
    and datediff(day, p.CreationDate, v.CreationDate) > @recentDaysExcluded
    and p.PostTypeId = 2
) i group by i.VoteDate order by i.VoteDate

fork query

edited jun 2 15 Who?

created dec 11 12 Mark Peters