Home Forums SQL Server 2014 Development - SQL Server 2014 Cast Varchar to Float Resulting In (Scientific) E Notation RE: Cast Varchar to Float Resulting In (Scientific) E Notation

  • August 26, 2016 at 7:14 am

    #1897785

    Jeff Moden (8/25/2016)

    P.S. You should also avoid the use of any of the "MONEY" datatypes and small scale DECIMAL types for any work with any operators other than simple addition and subtraction.

    I've been bitten by that problem too. I couldn't get to match the average until I discovered that the money data type was being used.

    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