Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Get original order quantities and dates, and find any changes or additions to quantities in subsequent order version(s) RE: Get original order quantities and dates, and find any changes or additions to quantities in subsequent order version(s)

  • what row are you expecting to see the fill factor...please provide example.

    the filled rate should go in the last row, that is the last version of an order row. see attached file

    is it really necessary to see all amendments on separate rows....could you not just show original qty / shipped qty and fill factor? what doe s the business say?

    The business requires to show every change that occurs in an order quantity from when it is originally entered into the system until its shipped.

    In the provided example, I think

    Original Ordered Quantity could show as

    40,000

    23,000

    no more changes in quantity then last version instead that showing a value in original ordered quantity, would show a value under shipped quantity.

    Thank you for your help.