0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

with Rep as
(
  select
    v.CreationDate,
    row_number() over (order by v.CreationDate) as RowNum,
    sum(case t.Name
      when 'UpMod' then 10
      when 'AcceptedByOriginator' then 15
      when 'DownMod' then -2
      else 0 end) as Rep
  from
    Votes v
    inner join VoteTypes t on t.Id = v.VoteTypeId
    inner join Posts p on p.Id = v.PostId
  where
   p.OwnerUserId = ##UserId## 
  group by
   v.CreationDate
)
select
  a.CreationDate,
  sum(b.Rep) as Rep
from
  Rep a
  inner join Rep b
    on b.CreationDate <= a.CreationDate
group by
  a.CreationDate
order by
  a.CreationDate

fork query

created oct 19 11 anonymous