USP_DATALIST_PARTICIPANTCOMMUNICATIONTEMPLATEBASICINFO

CREATE procedure dbo.USP_DATALIST_PARTICIPANTCOMMUNICATIONTEMPLATEBASICINFO
(
@ID uniqueidentifier = null,
@INTID int = null
)
as
set nocount on;

select EmailTemplate.Guid as ID, EmailTemplate.ID as ALTERNATEID, EmailTemplate.Name, EmailTemplate.Description, EVENTEMAILTEMPLATE.DATECHANGED, EVENTEMAILTEMPLATE.EVENTID, EmailTemplate.Subject, FAFTASK.ID, FAFTASK.NAME
from dbo.EmailTemplate (nolock)
inner join dbo.EVENTEMAILTEMPLATE (nolock) on EVENTEMAILTEMPLATE.EMAILTEMPLATEID = EmailTemplate.ID
inner join dbo.FAFTASK (nolock) on FAFTASK.ID = EVENTEMAILTEMPLATE.FAFTASKID
where EVENTEMAILTEMPLATE.CONFIRMATIONTYPECODE = 100
and (EmailTemplate.Deleted <> 1)
and (@ID is null or EmailTemplate.Guid = @ID)
and (@INTID is null or EmailTemplate.ID = @INTID)