UFN_EVENT_GETREGISTRATIONINFORMATION_TOITEMLISTXML

CREATE function dbo.UFN_EVENT_GETREGISTRATIONINFORMATION_TOITEMLISTXML
(
    @EVENTID uniqueidentifier,
    @PRICETYPECODEID uniqueidentifier = null
)
returns XML as begin
    return (
        select
            REGISTRATIONINFORMATIONID as [@REGISTRATIONINFORMATIONID],
            NAME as [@NAME],
            RESPONSETYPECODE as [@RESPONSETYPECODE],
            PERSONDETAILTYPECODE as [@PERSONDETAILTYPECODE],
            TEXTVALUE as [@TEXTVALUE],
            REGISTRATIONINFORMATIONOPTIONID as [@REGISTRATIONINFORMATIONOPTIONID],
            REQUIRED as [@REQUIRED],
            ALLPRICETYPES as [@ALLPRICETYPES],
            REGISTRATIONINFORMATIONPRICETYPES
        from dbo.UFN_EVENT_GETREGISTRATIONINFORMATION(@EVENTID, @PRICETYPECODEID)
        order by SECTIONSEQUENCE, SEQUENCE, PERSONDETAILTYPECODE
        for xml path('ITEM'),type,elements,root('EVENTREGISTRATIONINFORMATION'),BINARY BASE64
    );
end