spGetEmailTemplateDonationTransactions
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMailTemplateID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailTemplateDonationTransactions]
( @EMailTemplateID int ) AS
BEGIN
SELECT et.[GiftPaymentMethod],
count(et.DonationTransactionsID) Donations, sum(et.GiftAmount) GiftAmount
FROM DonationTransactions et
INNER JOIN Email e ON e.id = et.EmailID
WHERE e.EmailTemplateID = @EMailTemplateID
and isdeleted = 0
and et.[Status] = 1
GROUP BY et.[GiftPaymentMethod]
END