Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Arithmetic overflow error converting varchar to data type numeric. RE: Arithmetic overflow error converting varchar to data type numeric.

  • October 30, 2014 at 2:38 pm

    #1755921

    From the examples that you posted, I could only test the last one and the problem is with your precision which comes short. Changing it to 11 makes it work. Be aware that float is an approximate data type and will return unexpected data.

    SELECT CAST('735509.00053' AS DECIMAL(11,5))

    - CAST('735509.00047' AS DECIMAL(11,5)),

    convert(FLOAT,CAST('735509.00053' AS DECIMAL(11,5)))

    - convert(FLOAT,CAST('735509.00047' AS DECIMAL(11,5)))

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2