A divide-by-zero error was experienced.
Posted by:
james bond
Date: August 30, 2022 05:01PM
I've only recently started using SQL so that this question may be ridiculous, but I'm at a loss.
I have a query that creates a column but returns a divide by zero error. Could someone please explain what's wrong with this query?
IncreaseAmount = CASE WHEN sp.AccessLevel = 1 THEN NULL ELSE CONVERT(decimal(12,2), ROUND((ps.PayRate - (ps.LastAnnualizedPayRate / ps.AnnualizingFactor)), 2)) TO ROUND((ps.PayRate - (ps.LastAnnualizedPayRate / ps.AnnualizingFactor
Please provide advice.
Subject
Written By
Posted
A divide-by-zero error was experienced.
August 30, 2022 05:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.