UFN_REGISTRANT_GETREGISTRATIONINFORMATION_TOITEMLISTXML

CREATE function dbo.UFN_REGISTRANT_GETREGISTRATIONINFORMATION_TOITEMLISTXML
(
    @REGISTRANTID uniqueidentifier
)
returns XML as 
    begin
        return (
            select
                ID as [@ID],
                REGISTRATIONINFORMATIONID as [@REGISTRATIONINFORMATIONID],
                NAME as [@NAME],
                RESPONSETYPECODE as [@RESPONSETYPECODE],
                PERSONDETAILTYPECODE as [@PERSONDETAILTYPECODE],
                TEXTVALUE as [@TEXTVALUE],
                REGISTRATIONINFORMATIONOPTIONID as [@REGISTRATIONINFORMATIONOPTIONID],
                REQUIRED as [@REQUIRED]
            from dbo.UFN_REGISTRANT_GETREGISTRATIONINFORMATION(@REGISTRANTID)
            order by SECTIONSEQUENCE, SEQUENCE, PERSONDETAILTYPECODE
            for xml path('ITEM'),type,elements,root('REGISTRANTREGISTRATIONINFORMATION'),BINARY BASE64        
        );
    end