0

Please login or register to vote for this query.

(click on this box to dismiss)

Zero and non-zero accepted count. Self-accepted answers do not count.

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

-- How Unsung am I?
-- Zero and non-zero accepted count. Self-accepted answers do not count.
--select * from votetypes;
--select top 100 * from votes;
with A as (select p.id as [Post Link], v.creationdate, v.votetypeid,
case when votetypeid = 1 then 15 else case when votetypeid = 2 then 10 else -2 end end as drep
from votes v inner join posts p on v.postid = p.id
where v.votetypeid<4 and
p.owneruserid = 2093077)
select format (Year(creationdate), '0000') [year], format (Month(creationdate), '00') [month], sum(drep) as drep from A
group by Year(creationdate), Month(creationdate)
order by Year(creationdate) desc , Month(creationdate) desc

fork query

edited nov 29 anonymous

created jul 17 10 Eric