USP_DATALIST_FAFDEFAULTONLINECONFIRMATIONS

CREATE procedure dbo.USP_DATALIST_FAFDEFAULTONLINECONFIRMATIONS(@EVENTID uniqueidentifier)
as
    set nocount on;

    select EET.ID,
           case EET.CONFIRMATIONTYPECODE
        when 101 then 'Registrant confirmation screen'
        when 102 then 'Sponsor confirmation screen'
        when 103 then 'Donor confirmation screen'
        when 104 then 'Contact confirmation screen' end
    from dbo.EVENTEMAILTEMPLATE EET
  join EMAILTEMPLATE ET ON EET.EMAILTEMPLATEID = ET.ID
    where EVENTID = @EVENTID and CONFIRMATIONTYPECODE in (101, 102, 103, 104)
  order by confirmationtype