spLoadEReceiptKeysByDonationTransactionIDs

Parameters

Parameter Parameter Type Mode Description
@DonationTransactionIDs xml IN

Definition

Copy


            CREATE PROCEDURE [dbo].spLoadEReceiptKeysByDonationTransactionIDs
                @DonationTransactionIDs xml
            AS
            BEGIN
                SET NOCOUNT ON;

                SELECT
                der.LinkKey, der.DonationTransactionsID
                FROM @DonationTransactionIDs.nodes('/DonationTransactions/DonationTransaction') dti(el)
                INNER JOIN [dbo].[DonationEReceipt] der
                    ON dti.el.value('@ID', 'int') = der.[DonationTransactionsID]
            END