UFN_EVENTPRICE_GETRELATEDEVENTSWITHPRICES_TOITEMLISTXML

CREATE function dbo.UFN_EVENTPRICE_GETRELATEDEVENTSWITHPRICES_TOITEMLISTXML
(
    @EVENTIDS UDT_GENERICID readonly
)
returns XML
with execute as caller
as
begin
return(
    select
        EVENT.ID,
        EVENT.NAME [EVENTNAME],
        EVENTPRICE.ID [EVENTPRICEID],
        EVENTPRICE.NAME [EVENTPRICENAME],
        EVENTPRICE.EVENTREGISTRATIONTYPEID,
        EVENTREGISTRATIONTYPE.DESCRIPTION [EVENTREGISTRATIONTYPEDESCRIPTION],
        EVENTPRICE.AMOUNT [EVENTPRICEAMOUNT],
        EVENTPRICE.RECEIPTAMOUNT [EVENTPRICERECEIPTAMOUNT],
        EVENTPRICE.COST [EVENTPRICECOST],
        EVENTPRICE.REGISTRATIONCOUNT [EVENTPRICEREGISTRATIONCOUNT]
    from
        dbo.EVENT
        left join dbo.EVENTPRICE on EVENT.ID = EVENTPRICE.EVENTID
        left join dbo.EVENTREGISTRATIONTYPE on EVENTPRICE.EVENTREGISTRATIONTYPEID = EVENTREGISTRATIONTYPE.ID
    where
        EVENT.ID in (select ID from @EVENTIDS)
    order by EVENTNAME, EVENTPRICENAME
    for xml raw('ITEM'),type,elements,root('MULTICOMPONENTEVENTSWITHPRICES'),BINARY BASE64
)
end