hoseam (10/8/2012)

---

Hi

I have this code:

SELECT
[Policy_Id] = SNAP.POLICY_ID
,[Mex_Id] = FR.INV_PTF_NAME
,[Rebate_Amount_Gross] = ISNULL(CONVERT(DECIMAL(6,2),((FR.REBATE_RATE * SNAP.TOTAL_UNITS)/100)), 0.00)

and I get this error:
Arithmetic overflow error converting numeric to data type numeric.

please help.

SELECT 
	[Policy_Id] = SNAP.POLICY_ID 
	,[Mex_Id] = FR.INV_PTF_NAME
	,x.[Rebate_Amount_Gross]
FROM ...
CROSS APPLY (SELECT [Rebate_Amount_Gross] = (FR.REBATE_RATE * SNAP.TOTAL_UNITS)/100) x
ORDER BY x.[Rebate_Amount_Gross] DESC