0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/144716/reputation-history-from-data-explorer

Q&A about the site for musicians, students, and enthusiasts

; 
with upvQ as (
  select v.creationdate
  , sum(count(*)*5)
  over (order by v.creationdate) as score
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid = 2 --UpVote
  and p.posttypeid = 1 -- Q
  and p.owneruserid = ##uid##
  group by v.creationdate)
, upvA as (
  select v.creationdate
  , sum(count(*)*10)
  over (order by v.creationdate) as score
  from posts p 
  inner join votes v on v.postid = p.id
  where v.votetypeid = 2 --UpVote
  and p.posttypeid = 2 -- A
  and p.owneruserid = ##uid##
  group by v.creationdate)
select distinct 
       v.creationdate
     , upvq.score as [Upvote Question]
     , upvA.score as [Upvote Answer] 
from votes v 
left outer join upvQ on upvQ.creationdate = v.creationdate
left outer join upvA on upvA.creationdate = v.creationdate
order by v.creationdate

view current version

edited jun 22 14

created jun 22 14 rene