I have an application in which users are entering data in an interactive grid.
I would like to update a audit trail with all the changes made (ie copy some of the data from each changed row but not the unchanged rows).
Is the a best practises way to accomplish this or should I just copy all the rows and clear out the dups in a background process??