USP_BATCHBBNCMEMBERSHIP_DELETE

Deletes a Blackbaud Internet Solutions membership transaction from the system for a given batch.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_BATCHBBNCMEMBERSHIP_DELETE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            set nocount on;

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

            delete from dbo.BBNCDOWNLOADEDTRANSACTION
            where ID = (select BATCHMEMBERSHIPDUESBBNCINFO.BBNCID from dbo.BATCHMEMBERSHIPDUESBBNCINFO where BATCHMEMBERSHIPDUESBBNCINFO.ID = @ID);

            exec USP_BATCHMEMBERSHIPDUE_DELETE @ID, @CHANGEAGENTID

                        return 0;

            return 0;