UFN_EVENTPREFERENCEGROUP_GETRELATEDEVENTPREFERENCEGROUPS_TOITEMLISTXML

CREATE function dbo.UFN_EVENTPREFERENCEGROUP_GETRELATEDEVENTPREFERENCEGROUPS_TOITEMLISTXML
(
    @EVENTIDS UDT_GENERICID readonly
)
returns XML
with execute as caller
as
begin
return(
    select
        EVENTPREFERENCEGROUP.ID [EVENTPREFERENCEGROUPID],
        EVENTPREFERENCEGROUP.EVENTID [EVENTPREFERENCEGROUPEVENTID],
        EVENT.NAME [EVENTPREFERENCEGROUPEVENTNAME],
        EVENTPREFERENCEGROUP.NAME [EVENTPREFERENCEGROUPNAME]
    from
        dbo.EVENTPREFERENCEGROUP
        inner join dbo.EVENT on EVENTPREFERENCEGROUP.EVENTID = EVENT.ID
    where
        EVENTPREFERENCEGROUP.EVENTID in (select ID from @EVENTIDS)
    order by EVENTPREFERENCEGROUPEVENTNAME, EVENTPREFERENCEGROUPNAME
    for xml raw('ITEM'),type,elements,root('MULTICOMPONENTEVENTPREFERENCEGROUPS'),BINARY BASE64
)
end