USP_BBNC_MAPRULETOBATCH

Maps a batch to a Blackbaud Internet Solutions mapping rule.

Parameters

Parameter	Parameter Type	Mode
@MAPPINGRULEID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_MAPRULETOBATCH
            (
                @MAPPINGRULEID uniqueidentifier,
                @BATCHID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            with execute as owner
            as 
            set nocount on;

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

            if @CHANGEDATE is null
                set @CHANGEDATE = getdate();

            begin try
                insert into dbo.NETCOMMUNITYMAPPINGRULEBATCH(ID, MAPPINGRULEID, BATCHID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(newid(), @MAPPINGRULEID, @BATCHID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

            return 0;