I need to duplicate records in a table based on an ID#
so I can expire the first copy and set the new records as current. I'm doing this because we cannot update records directly, we have to expire old records and update them using a duplicate of them.
So I have a 'status' and 'completion date' field where id=1
I need to update the status and date, but I need to make a copy of that record, re-insert into the same table, and set the current flag = true
Any ideas? Thanks
so I can expire the first copy and set the new records as current. I'm doing this because we cannot update records directly, we have to expire old records and update them using a duplicate of them.
So I have a 'status' and 'completion date' field where id=1
I need to update the status and date, but I need to make a copy of that record, re-insert into the same table, and set the current flag = true
Any ideas? Thanks