USP_DATALIST_PARTICIPANTCOMMUNICATIONTEMPLATES

CREATE procedure dbo.USP_DATALIST_PARTICIPANTCOMMUNICATIONTEMPLATES(
  @EVENTID uniqueidentifier,
  @EVENTEMAILTEMPLATEID uniqueidentifier = null
)
as
    set nocount on;

    select
    EET.ID
      ,isnull(FT.NAME, '')
    ,ET.[SUBJECT]
    ,ISDEFAULTFORTASK
    ,ET.NAME
      ,ET.[DESCRIPTION]
    ,ET.ContentHTML
    ,FAFTASKID
    ,EET.DATECHANGED
    ,ET.ID

    from dbo.EVENTEMAILTEMPLATE EET
  join EMAILTEMPLATE ET ON EET.EMAILTEMPLATEID = ET.ID
  LEFT OUTER JOIN FAFTASK FT on EET.FAFTASKID = FT.ID
    where EET.EVENTID = @EVENTID and EET.CONFIRMATIONTYPECODE = 100
  AND (EET.ID = @EVENTEMAILTEMPLATEID or @EVENTEMAILTEMPLATEID is null)