I have a variable table in a stored procedure that stores order quantities. each row is differentiated by a version number. sometimes the quantities among same order but different rows/ versions are same, sometimes are different.
OrderNumber VersionNumber ItemNumber OrderQuantity
S20026 4 10568 23000.000000000000000000
S20026 5 10568 23000.000000000000000000
I would like to learn of a way to compare each row and select only those that show a different quantity for same order, in the case of sample data above, because the quantities are the same, i would then show the newest version with same quantity.
I hope this is clear, is the only part I am missing n my store procedure.
There is more information in a separate question I asked yesterday: Q_28412460