UFN_EVENT_GETRELATEDEVENTCURRENCIES_TOITEMLISTXML

CREATE function dbo.UFN_EVENT_GETRELATEDEVENTCURRENCIES_TOITEMLISTXML
(
    @PACKAGESPRICES xml,
    @MULTICOMPONENTEVENTSWITHPRICES xml
)
returns XML
with execute as caller
as
begin
    return
    (select
        EVENT.ID [EVENTCURRENCYEVENTID],
        EVENT.BASECURRENCYID,
        APPEAL.BASECURRENCYID as [TEAMFUNDRAISINGBASECURRENCYID]
    from dbo.EVENT
    left join dbo.APPEAL on APPEAL.ID = EVENT.APPEALID
    where
        EVENT.ID in
            (
                select
                    PACKAGESPRICESITEM.ELEMENT.value('EVENTPRICEEVENTID[1]', 'uniqueidentifier') [EVENTID]
                from
                    @PACKAGESPRICES.nodes('/PACKAGESPRICES/ITEM') PACKAGESPRICESITEM(ELEMENT)

                union

                select
                    MULTICOMPONENTEVENTSWITHPRICESITEM.ELEMENT.value('ID[1]', 'uniqueidentifier')
                from
                    @MULTICOMPONENTEVENTSWITHPRICES.nodes('/MULTICOMPONENTEVENTSWITHPRICES/ITEM') MULTICOMPONENTEVENTSWITHPRICESITEM(ELEMENT)
            )
    order by
        EVENT.NAME
    for xml raw('ITEM'),type,elements,root('EVENTCURRENCY'),BINARY BASE64)
end