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'