Todd Taylor's Blog - Avoiding Divide by Zero Error in Microsoft SQL

Avoiding Divide by Zero Error in Microsoft SQL

Monday, July 25, 2005 5:58:42 PM UTC :: Filed Under SQL

Neither humans nor computes can divide by zero, so if your SQL script has a variable in the denominator of an equation, be sure to safe-guard against a potential divide-by-zero error:

CASE
WHEN @AveWorkDays = 0 THEN 0
ELSE
ISNULL(SUM(CAST(ItemInventory.QtyDistributed As decimal))/@AveWorkDays, 0)
END

Comments [0]

Comments are closed.

Navigation

On this page....