SF_Merge
SF_Merge
Usage
SF_Merge
merges a list of records into one master record. This is only supported for the objects Account, Lead, Contact, and Individual. You must give the stored procedure the master record you want to merge into, and a list of all the records you want to merge. Each merge (into a given master record) must be done one at a time.
Syntax
EXEC SF_Merge 'linked_server','table_name','master_record','records_to_merge'
where
- linked_server is your linked server name.
- table_name is ‘Account’,’Lead’,’Contact’, or ‘Individual’.
- master_record is a single ID of a record in the given table that you want to merge records into.
- records_to_merge is a comma-separated list of Ids that you want to merge into the master record.
Example
EXEC SF_Merge 'SALESFORCE','Account','0015f000002GbpDAAS','0015f000003ozuqAAA,0015f000003ozurAAA'