spGetEmailCapWizTransactions
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMailID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailCapWizTransactions]
( @EMailID int ) AS
BEGIN
SELECT et.[AlertTitle],
count(et.CapWizTransactionsID) Actions
FROM CapWizTransactions et
WHERE et.EmailID = @EmailID
and isdeleted = 0
GROUP BY et.[AlertTitle]
END