fiogf49gjkf0d You simply change the ContactID field to your New ContactID......
UPDATE IBC_CONTACT_GYM
SET CONTACTID = MyNewContactID (Surviving 'Merge To' Record)
WHERE CONTACTID = MyOLDContactId (Bye Bye records).
Oh, and ModifyDate, ModifyUser of course....
SLX changes the ContactId and ContactName for History, Activity tables.... no records are actually 'merged' in these two tables.....
Address is another story....
|