Home Forums SQL Server 7,2000 Administration How to fix "Divide by zero error" in SQL Server RE: How to fix "Divide by zero error" in SQL Server

  • November 8, 2015 at 9:58 pm

    #1838473

    You can also do this

    SELECT Dividend / ISNULL(NULLIF(Divisor,0),1) AS Result