SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) / Arithmetic overflow error converting numeric to data type numeric / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:15:38 GMT20RE: Arithmetic overflow error converting numeric to data type numerichttp://www.sqlservercentral.com/Forums/Topic1369656-392-1.aspx[quote][b]hoseam (10/8/2012)[/b][hr]HiI 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.[/quote]Examine the Rebate_Amount_Gross values and check for yourself if they will fit into a decimal (6,2);[code="sql"]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) xORDER BY x.[Rebate_Amount_Gross] DESC[/code]Mon, 08 Oct 2012 02:58:41 GMTChrisM@WorkArithmetic overflow error converting numeric to data type numerichttp://www.sqlservercentral.com/Forums/Topic1369656-392-1.aspxHiI 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.Mon, 08 Oct 2012 01:53:29 GMThoseam