USP_BATCHIGNOREDUPLICATE_ADD

Adds a row in BatchIgnoreDuplicate table for which duplicate check need to be ignored.

Parameters

Parameter	Parameter Type	Mode
@BATCHID	uniqueidentifier	IN
@ROWID	nvarchar(36)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE procedure dbo.USP_BATCHIGNOREDUPLICATE_ADD 
            (@BATCHID uniqueidentifier,
            @ROWID nvarchar(36),
            @CHANGEAGENTID uniqueidentifier = null,
      @CONSTITUENTID uniqueidentifier = null)
        as
        set nocount on;

        declare @CURRENTDATE datetime;

        if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        set @CURRENTDATE = GetDate();

        if not exists(select ROWID from dbo.BATCHIGNOREDUPLICATE where BATCHID = @BATCHID and ROWID = @ROWID and CONSTITUENTID = @CONSTITUENTID)
            begin
                --Insert the batch row.

                insert into dbo.BATCHIGNOREDUPLICATE(BATCHID,
                    ROWID,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED, 
          CONSTITUENTID)
                values (@BATCHID,
                    @ROWID,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE,
          @CONSTITUENTID);
            end