USP_BBNC_TRANSACTION_CLEARDOWNLOADEDTRANSACTIONS

Clears Blackbaud Internet Solutions transactions from the list of downloaded transactions.

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONIDS	xml	IN

Definition

Copy



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

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

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