UFN_FAFEVENT_GETEVENTEMAILTEMPLATE

CREATE function dbo.UFN_FAFEVENT_GETEVENTEMAILTEMPLATE(@EVENTID uniqueidentifier)
returns table
  as return 
    select 
      0 as ID, 
      CONFIRMATIONTYPECODE as ETYPECODE, 
      ISAVAILABLETOINDIVIDUAL as FORINDIVIDUAL, 
      ISAVAILABLETOHOUSEHOLD as FORHH, 
      ISAVAILABLETOTEAMMEMBER as FORTEAMMEMBER, 
      ISAVAILABLETOTEAMLEADER as FORTEAMLEADER, 
      ISAVAILABLETOCOMPANYLEADER as FORCOMPLEADER, 
      EET.ISACTIVE,
      ISAVAILABLETOFUNDRAISINGCOACH as FORFUNDCOACH,
      ISAVAILABLETOSPONSOR as FORSPONSOR, 
      RECIPIENTDONOR, RECIPIENTPROSPECT, 
      RECIPIENTINDIVIDUAL, 
      RECIPIENTHOUSEHOLDMEMBER as RECIPIENTHHMEMBER, 
      RECIPIENTHOUSEHOLDLEADER as RECIPIENTHHLEADER, 
      RECIPIENTTEAMMEMBER, 
      RECIPIENTTEAMLEADER, 
      RECIPIENTCOMPANYLEADER as RECIPIENTCOMPLEADER , 
      RECIPIENTSTATUSPREVIOUS as PREVIOUSSTATUS, 
      RECIPIENTSTATUSCURRENT as CURRENTSTATUS,
      REPLACE(ET.NAME, E.NAME, '[[EVENTNAME]]') as NAME,
      ET.DESCRIPTION,
      SUBJECT,
      cast(ContentHTML as nvarchar(max)) CONTENTHTML,
      '00000000-0000-0000-0000-000000000000' as GUID,
      FROMADDRESS,
      FROMDISPLAYNAME,
      REPLYADDRESS,   
      PRIORITY,
      DELETED,
      TYPE,
      ET.ID as COPYSOURCEID,
      @EVENTID as COPYBATCHGUID,
      CCEMAILADDRESSES,
      EET.NCNOTIFICATIONID,
      ET.DATASOURCEID,
      NOTIFICATIONTYPEID,
      REPLACE(NCN.DISPLAYNAME, E.NAME, '[[EVENTNAME]]') as NOTICATIONNAME,
      REPLACE(NCN.DESCRIPTION, E.NAME, '[[EVENTNAME]]') as NOTICATIONDESCRIPTION,
      NCN.ENABLED,
      ISAVAILABLETOHOUSEHOLDMEMBER as FORHHMEMBER,
      EET.FAFTASKID,
      EET.ISDEFAULTFORTASK
      from 
      dbo.EVENTEMAILTEMPLATE EET
      join dbo.EVENT E on EET.EVENTID = E.ID
      join dbo.EmailTemplate ET on EET.EMAILTEMPLATEID = ET.ID 
      left join dbo.EMAILTEMPLATEEXTENSION EXT on ET.ID = EXT.EMAILTEMPLATEID
      left join dbo.NC_Notification NCN on NCN.ID = EET.NCNOTIFICATIONID
    where
      EVENTID = @EVENTID