SQL Server 2000

[Josh01]

I am trying a simple percentage analysis using two fields, i keep getting a divide by zero error and can not seem to get around it. I am aware that there are zeros in one of the columns but cant seem to successfully change/ignore them.

 

[Tunta]

Hi Josh01,

declare @d int
select @d=0
select case @d
when 0 then null
else 8/@d end as res

select @d=2
select case @d
when 0 then null
else 8/@d end as res


u can try something like this !!!

cheers