0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

select datepart(yy,creationdate) *100 
     + datepart(mm,creationdate) as yyyymm
     , sum(count(p.id)) 
        over (
           --partition by datepart(yy,creationdate) *100 
           --           + datepart(mm,creationdate) 
           order by  datepart(yy,creationdate) *100 
                   + datepart(mm,creationdate)
           ROWS UNBOUNDED PRECEDING )
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where t.tagname='systemc'
group by datepart(yy,creationdate) *100 
   + datepart(mm,creationdate) 
     order by 1

view current version

edited mar 16 14

created mar 16 14 rene