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)

  • September 5, 2013 at 9:23 am

    #1647766

    ChrisM@Work (9/5/2013)

    Almost clear enough to make a stab at it...could you post the expected result set, or, alternatively, add an extra column say 'NewAmount' to your sample data which contains the values you are expecting to see in the 'Amount' column? Cheers.

    “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