if then statement help

[awholtsIT]

SQL 2005

I'm trying to eliminate a division by zero issue.
Can someone assist with proper syntax for a statement like;

if sum(Field 1)[denominator] = 0
then 0
else sum(field 2)[numerator]/sum(field 1) [denominator]

Fields 1 and 2 also need to be summed.

I keep getting an invalid expression on my line where the if function is stated.

Apreciate any help.

Thanks,

Andrew

 

[bborissov]

SELECT CASE WHEN SUM(field 1) = 0
                 THEN 0
            ELSE sum(field 2)/sum(field 1)
       END

IF can not be used in SELECT statement.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[awholtsIT]

Thanks
That helped.

Thank you very much again,

Andrew

 

[r937]

SELECT COALESCE(SUM(field2)/NULLIF(SUM(field1),0))



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[markros]

I also prefer using NULLIF technique.

In other words,

select sum(Field1)/NULLIF(Sum(Field2,0))