USP_MERGE_CONSTITUENT_WITHFAFDATA

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATECHANGED	datetime	IN

Definition

Copy



create procedure dbo.USP_MERGE_CONSTITUENT_WITHFAFDATA
(
  @SOURCEID uniqueidentifier,
    @TARGETID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
  @DATECHANGED datetime
)
as
begin

    update dbo.ADDRESSBOOKFAF set 
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID

  update dbo.FAFPARTICIPANTGALLERYIMAGES set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID    

  update dbo.SITEIMAGESEXTENSION set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID        

  update dbo.VIDEO set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID

  update dbo.EMAILJOBEXTENSION set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID

  update dbo.FAFCOMMUNICATIONSLOG set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID

  update dbo.FAFDONATION set
    CONSTITUENTID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where CONSTITUENTID = @SOURCEID

  update dbo.FAFDONATION set
    RECOGNITIONID = @TARGETID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @DATECHANGED
  where RECOGNITIONID = @SOURCEID

end