Home Forums SQL Server 2008 SQL Server Newbies Recalculate Wages (Reposted for SQL 2008 with additional columns) RE: Recalculate Wages (Reposted for SQL 2008 with additional columns)

  • dwain.c (9/10/2013)


    Perhaps it is overkill but is this a case where "fudge rounding" would help?

    http://www.sqlservercentral.com/articles/Financial+Rounding/88067/

    Dwain - possibly. The OP is using the rounded result of an earlier calculation to perform subsequent calculations. Without knowing what rounding technique was used in the earlier calculations, balancing the subsequent figures is going to be difficult.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden