USP_BBATARGETGIFTRANGESFILEIMPORT_DELETE

This procedure is used by the Target Analytics Target Gift Ranges File Import Record Operation for saving the information from a Target Analytics Target Gift Ranges Import File to the database.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_BBATARGETGIFTRANGESFILEIMPORT_DELETE (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

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

                begin try
                    exec dbo.USP_TARGETGIFTRANGE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;