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