left outer join and replacing null values & syntax check

HI There,

I have procedure that sums so rows for a voting poll.I have 2 issues:

1. I need to return the leader of the voting as a percentage of the overal count votefor - voteagainst
2. I'm also getting null values which I want to replace with zeros if no votes are registered for that presenter.

Could someone help me fix this query please?

Sean


!---------------- results

8      Jackie      female          NULL      NULL      NULL
10      Megan      female          NULL      NULL      NULL
11      Alexandra      female          50      50      0.5
12      Mimi      female          NULL      NULL      NULL
14      Yousha      female          NULL      NULL      NULL
15      Angela      female          33      66      0.333333333333333

!--- sample data presenters
11      Alexandra      <p>this is my profile</p>      female    

--------------------- sample data compweek

2      11      5/10/2007 6:40:46 AM      1      0
2      11      5/10/2007 6:40:46 AM      0      1
3      15      5/10/2007 6:40:46 AM      1      0
3      15      5/10/2007 6:40:46 AM      0      1
3      15      5/10/2007 6:40:46 AM      0      1

--------------- table

CREATE TABLE [dbo].[tblCompWeek_299](
      [UserID] [int] NOT NULL,
      [PresenterID] [int] NOT NULL,
      [Created] [datetime] NOT NULL,
      [VoteFor] [int] NULL,
      [VoteAgainst] [int] NULL
) ON [PRIMARY]



!-----------------------------------------

procedure

declare @Gender varchar(20)

set @Gender = 'female'

 
select a.PresenterID,
a.presenterName,
a.PresenterGender,
CAST(CAST(SUM(CASE WHEN pr.VoteFor = 1 THEN 1 WHEN pr.VoteFor = 0 THEN 0 END)
AS DECIMAL(16,2)) / CAST(count(*) AS DECIMAL(16,2)) * 100 AS INT) as VoteFor,

CAST(CAST(SUM(CASE WHEN pr.VoteAgainst = 1 THEN 1 WHEN pr.VoteAgainst = 0 THEN 0 END)
AS DECIMAL(16,2)) / CAST(count(*) AS DECIMAL(16,2)) * 100 AS INT) as VoteAgainst,

CAST(SUM(CASE WHEN VoteFor = 1 THEN 1 WHEN VoteFor = 0 THEN 0 END) AS INT)
-
CAST(SUM(CASE WHEN VoteAgainst = 1 THEN 1 WHEN VoteAgainst = 0 THEN 0 END) AS INT)
as TotalForMinusAgainstVotes

from dbo.tblPresenters a
left outer JOIN dbo.tblCompWeek_299 pr
ON a.PresenterID = pr.PresenterID
WHERE PresenterGender=@Gender
group by a.PresenterID,pr.PresenterID,a.presenterName,a.PresenterGender