USP_BBNC_TRANSACTION_MARKUNSUCCESSFULDOWNLOADS

Adds Blackbaud Internet Solutions transactions to the list of unsuccessful downloads.

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONIDS	xml	IN

Definition

Copy



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

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

                insert into dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
                (
                    ID
                )
                select
                    T.C.value('text()[1]', 'int')
                from
                    @TRANSACTIONIDS.nodes
                    (
                        '/TransactionIds/int'
                    ) T(C)
                    left join dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION on T.C.value('text()[1]', 'int') = BBNCUNSUCCESSFULDOWNLOADTRANSACTION.ID
                where
                    BBNCUNSUCCESSFULDOWNLOADTRANSACTION.ID is null;

                return 0;