Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul White Exact and Approximate RE: Exact and Approximate

  • January 3, 2012 at 3:43 am

    #1427610

    OOPS!! Sorry, Paul - you are completely right.

    I had missed the rounding of the decimal result; I thought that the decimal result was the exact and correct result. Even when running the code I posted above (that shows the extra decimals), I simply overlooked that the DECIMAL result was 0.123457 instead of 0.1234567. My bad; my apologies.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/