USP_BBNC_TRANSACTION_CLEARUNSUCCESSFULDOWNLOADS

Clears Blackbaud Internet Solutions transactions from the list of unsuccessful downloads.

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONIDS	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_TRANSACTION_CLEARUNSUCCESSFULDOWNLOADS
            (
                @TRANSACTIONIDS xml
            )
            as
                set nocount on;

                delete from dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
                from
                    dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
                    cross apply @TRANSACTIONIDS.nodes
                    (
                        '/TransactionIds/int[text() = sql:column("BBNCUNSUCCESSFULDOWNLOADTRANSACTION.ID")]'
                    ) T(C);

                return 0;