USP_DATALIST_EVENTSPONSORSHIPOPTIONCHECK

create procedure dbo.USP_DATALIST_EVENTSPONSORSHIPOPTIONCHECK(
    @SELECTIONOPTIONS xml
)
as
    set nocount on;

    SELECT T.c.value('(ID)[1]','uniqueidentifier') EVENTSPONSORSHIPTYPEID, EST.NAME OPTIONNAME, E.NAME EVENTNAME
    FROM @SELECTIONOPTIONS.nodes('/ArrayOfEventDataRecordNameIDPair/EventDataRecordNameIDPair') T(c)
    inner join dbo.EVENTSPONSORSHIPTYPE EST ON EST.ID = T.c.value('(ID)[1]','uniqueidentifier')
    inner join dbo.Event E on E.ID = EST.EventID