UFN_EVENTPRICEBENEFIT_GETRELATEDEVENTPRICEBENEFITS_TOITEMLISTXML

CREATE function dbo.UFN_EVENTPRICEBENEFIT_GETRELATEDEVENTPRICEBENEFITS_TOITEMLISTXML
(
    @EVENTIDS UDT_GENERICID readonly
)
returns XML
with execute as caller
as
begin
    return
    (select
        EVENTPRICEBENEFIT.ID [EVENTPRICEBENEFITID],
        BENEFIT.ID [BENEFITID],
        BENEFIT.NAME [BENEFITNAME],
        BENEFIT.DESCRIPTION [BENEFITDESCRIPTION],
        EVENTPRICEBENEFIT.EVENTBASECURRENCYTOTALVALUE [BENEFITTOTALVALUE],
        EVENTPRICEBENEFIT.DETAILS [EVENTPRICEBENEFITDETAILS],
        EVENTPRICEBENEFIT.EVENTPRICEID,
        EVENTPRICE.EVENTID [EVENTPRICEEVENTID],
        EVENTREGISTRATIONTYPE.DESCRIPTION [EVENTREGISTRATIONTYPEDESCRIPTION],
        EVENT.NAME [EVENTNAME]
    from
        dbo.EVENTPRICEBENEFIT
        inner join dbo.BENEFIT on EVENTPRICEBENEFIT.BENEFITID = BENEFIT.ID
        inner join dbo.EVENTPRICE on EVENTPRICEBENEFIT.EVENTPRICEID = EVENTPRICE.ID
        inner join dbo.EVENTREGISTRATIONTYPE on EVENTPRICE.EVENTREGISTRATIONTYPEID = EVENTREGISTRATIONTYPE.ID
        inner join dbo.EVENT on EVENTPRICE.EVENTID = EVENT.ID
    where
        EVENTPRICE.EVENTID in (select ID from @EVENTIDS)
    order by EVENTNAME, EVENTREGISTRATIONTYPEDESCRIPTION, BENEFITDESCRIPTION
    for xml raw('ITEM'),type,elements,root('MULTICOMPONENTEVENTPRICEBENEFITS'),BINARY BASE64)
end