USP_DATALIST_ACTION_TEMPLATE
Returns acknowledgement template information
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACTIONITEMID | uniqueidentifier | IN | ACTIONITEMID |
Definition
Copy
create procedure dbo.USP_DATALIST_ACTION_TEMPLATE(@ACTIONITEMID uniqueidentifier = NULL)
with execute as owner
as
set nocount on;
SELECT TOP 1 ET.NAME,
ET.DESCRIPTION,
ET.CONTENTHTML ,
ET.FROMADDRESS,
ET.FROMDISPLAYNAME,
ET.SUBJECT
FROM EmailTemplate ET
JOIN ACTIONITEMMESSAGETEXT AM
-- ON CONVERT(INT, AM.THANKYOUEMAILTEXT) = ET.ID
ON AM.EMAILTEMPLATEID = ET.ID
WHERE AM.ACTIONITEMID = @ACTIONITEMID