Q&A for professionals, academics, and students working within the systems development life cycle
set nocount on
declare @VoteStats table (up int, down int)
up = sum(case when VoteTypeId = 2 then 1 else 0 end),
down = sum(case when VoteTypeId = 3 then 1 else 0 end)
where VoteTypeId in (2,3) and CreationDate > '01-01-2010' and CreationDate < '01-01-2011'
set nocount off
select (100 * down/up) as percentage, up, down from @VoteStats