3

Please login or register to vote for this query.

(click on this box to dismiss)

Reputation earned per month from questions at least 10 days old at the time of vote. (Use the graph tab!)

Q&A for amateur radio enthusiasts

select 
sum(case when v.VoteTypeId = 2 then 10 else -2 end) as [Votes], 
DATEPART(Year, v.CreationDate) as [Year], 
DATEPART(Month, v.CreationDate) as [Month]
from votes v inner join Posts p on v.PostId=p.id 
WHERE p.OwnerUserId=##UserId## and v.VoteTypeId in (2,3)
and datediff(day, p.CreationDate, v.CreationDate) > 10
group by DATEPART(Year, v.CreationDate), DATEPART(Month, v.CreationDate)
order by [Year] DESC, [Month] DESC

view current version

edited sep 18 12

created sep 18 12 Mark Peters