spGetEmailTemplateFromListID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ListID | int | IN |
Definition
Copy
CREATE procedure dbo.spGetEmailTemplateFromListID
(
@ListID int
)
as
SELECT et.[ID], [ClientsID], [Name], [Description], [OwnerID], [Deleted], [Guid], [ContentHTML], [ContentText], [FromAddress], [FromDisplayName], [Subject], [Priority], [ReplyAddress], [ReturnReceipt], [ReturnReceiptAddress], [ForwardDSN], [ForwardDSNAddress], [Type], [IsInternalUse]
FROM [dbo].[EmailTemplate] as et
INNER JOIN [dbo].[EmailTemplate_EmailList] as etel ON et.[ID] = etel.EmailTemplateID
WHERE etel.EmailListID = @ListID