USP_GET_DIRECTORYEMAILCOUNT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientIP | nchar | IN | |
| @TemplateID | int | IN |
Definition
Copy
create procedure dbo.USP_GET_DIRECTORYEMAILCOUNT
(
@ClientIP nchar(45),
@TemplateID int
)
AS
BEGIN
DECLARE @count int
SELECT count(*) as [EmailCount]
FROM [dbo].EmailJob
WHERE ClientIP= @ClientIP
AND EmailTemplateID = @TemplateID
AND CreateDate > DATEADD(HOUR, -1, GETUTCDATE())
END