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 Ubuntu users and developers

declare @recentDaysExcluded int = 10

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
order by 
  [VoteDate] ASC

view current version

edited dec 11 12

created dec 11 12 Mark Peters