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, CreationDate,
coalesce(sum(
  case 
    when VoteTypeId = 2 then 1 
    when VoteTypeId = 3 then -1 
    else 0 
  end),0) as Score 
from      #t
left join Votes v on AnalisysDate=CreationDate
where     PostId = 194812 and VoteTypeId in (2,3)
group by  AnalisysDate,CreationDate
order by  AnalisysDate asc

drop table #t

fork query

created may 4 11 Sklivvz