[dbo].[Forum_EmailTemplatesByModuleIDGet]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_EmailTemplatesByModuleIDGet

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ModuleID	int	4

SQL Script

CREATE PROCEDURE  dbo.Forum_EmailTemplatesByModuleIDGet
(
@ModuleID int
)
AS
SELECT
    EmailTemplateID,
    EmailTemplateName
FROM
    dbo.Forum_EmailTemplates ET
INNER JOIN
    dbo.Forum_TemplateTypes TT ON ET.ForumTemplateTypeID = TT.ForumTemplateTypeID
WHERE
    ET.ModuleID = @ModuleID
AND
    TemplateTypeName = 'Email'
AND
    ET.IsActive = 1

GO

Uses

[dbo].[Forum_EmailTemplates]
[dbo].[Forum_TemplateTypes]
dbo