mburk1968
asked on
SQL Calculation
I have the following two calculations below. I need to combine these into one.
A. SELECT ISNULL(CAST((@IndemReserve - t.Claims_Retention) * t.Treaty_Claims_PCT AS NUMERIC(12, 2)), 0.00)
B. SELECT ISNULL(CAST((@ResultOfA / nullif(@IndemReserve, 0)) * @ExpReserve AS NUMERIC(12, 2)), 0.00)
Thank you for your help.
A. SELECT ISNULL(CAST((@IndemReserve
B. SELECT ISNULL(CAST((@ResultOfA / nullif(@IndemReserve, 0)) * @ExpReserve AS NUMERIC(12, 2)), 0.00)
Thank you for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand what you meant now. Thanks
ASKER