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)

  • April 24, 2014 at 1:16 pm

    #1708567

    Are you asking for the stored procedure after I added your code?

    What I tired so far was to modified the CASE statement where the Filled Rate gets calculated:

    CASE

    WHEN cte2.QuantityOrdered <> cte_oqty.QuantityOrdered

    AND cte2.QuantityOrdered <> cte2.ShippedQuantity

    THEN cte2.QuantityOrdered

    WHEN cte2.ShippedQuantity = 0

    THEN 0

    ELSE cte_oqty.QuantityOrdered

    END AS OrgQty

    I can upload the stored procedure too if needed.