Msg 8134, Level 16, State 1, Line 1480 Divide by zero error encountered.

Error Message: Msg 8134, Level 16, State 1, Line 1480 Divide by zero error encountered.

What this error message tell us that we are trying to divide a numerator value by zero.

The best way to handle this kind of error in sql code is by using NULLIF or case statement.

USE NULLIF

Select Numerator/NULLIF(Denominator, 0) FROM table

In this above SQL statement, whenever Denominator is converted to 0 if there is missing value.

USE CASE Statement

Select CASE WHEN DENOMINATOR = 0 Then NULL ELSE Numerator/Denominator
FROM Table