0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

-- Enter Query Title
-- Enter Query Description

create table #t (AnalisysDate datetime)

declare @d datetime
set @d = '2008-10-11'

while(@d<='2011-02-21')
begin
 insert into #t (AnalisysDate) values (@d)
 set @d = dateadd(day,1,@d)
end

--select * from #t order by AnalisysDate

select AnalisysDate, sum(case when votetypeid=2 then 1 when votetypeid = 3 then -1 else 0 end) as score 
from #t
full outer join votes v  on creationdate=AnalisysDate
--where (postid = 194812 and votetypeid in (2,3)) or (postid is null and votetypeid is null)
group by AnalisysDate
order by AnalisysDate asc

drop table #t

fork query

created may 4 11 Sklivvz