I have a situation where I need to copy a "policy", allow an operator to work on
the copy, and eventually throw the copy away or update the original policy with
the data from the copy. This gets a little complicated as the "policy" consists
of multiple records in 6 tables. Some of the tables contain multiple records
(like an line item table connected to an order table). Obviously the new records
would have to be connected via the correct primary key (from the just
I can imagine how to do this manually in an sp but it involves a lot of logic.
Does anyone know of an easier way to accomplish this?? All tables use RI and
connected via constraints.