We have a nighly routine that append to a table the status of record for that night. Its creates an audit trail for the records stats. When the status becomes "C" we want to append to the table on the date (the nightly rountine) it became "C". But then we want to stop appending that specific record for all subequent nightly updates. Any ideas how to do this?
