Hopefully one of you very smart people can help me out. I imported data into
a table that contains customer payment information. Multiple months of
payments are included in this data. Often all rows are duplicates including
a the quantity column. Is there an easy way to compare rows and when all
columns are the same to tally the quantity and delete all rows except one
and then update the quantity to the correct number. I have written a cmd
file that accomplishes this by stepping through the table with a cursor and
uses a boatload of nested if / then statements to check is all the rows are
exactly the same, but this just seems real inefficient to me. I hope I am
missing a way to compare two entire rows. Any ideas would be much
appreciated.
