USP_DATALIST_EVENTCOMMUNICATIONTEMPLATECHECKEXISTING

CREATE procedure dbo.USP_DATALIST_EVENTCOMMUNICATIONTEMPLATECHECKEXISTING(
    @SELECTIONTEMPLATES xml
)
as
    set nocount on;

    SELECT T.c.value('(ID)[1]','uniqueidentifier') EMAILTEMPLATEGUID, ET.NAME TEMPLATENAME, E.NAME EVENTNAME, ET.SUBJECT TEMPLATESUBJECT
    FROM @SELECTIONTEMPLATES.nodes('/ArrayOfEventDataRecordNameIDPair/EventDataRecordNameIDPair') T(c)
    inner join dbo.EMAILTEMPLATE ET ON ET.GUID = T.c.value('(ID)[1]','uniqueidentifier') and ET.Deleted = 0
  inner join dbo.EVENTEMAILTEMPLATE EET ON EET.EMAILTEMPLATEID = ET.ID 
  inner join dbo.Event E on E.ID = EET.EventID