UFN_REGISTRANT_GETREGISTRATIONINFORMATION_FROMITEMLISTXML

CREATE function dbo.UFN_REGISTRANT_GETREGISTRATIONINFORMATION_FROMITEMLISTXML
(
    @REGISTRANTREGISTRATIONINFORMATION xml
)
returns table as
return (
    select
        T.c.value('(@ID)[1]','uniqueidentifier') as 'ID',
        T.c.value('(@REGISTRATIONINFORMATIONID)[1]','uniqueidentifier') as 'REGISTRATIONINFORMATIONID',
        T.c.value('(@NAME)[1]','nvarchar(100)') as'NAME',
        T.c.value('(@RESPONSETYPECODE)[1]','int') as 'RESPONSETYPECODE',
        T.c.value('(@PERSONDETAILTYPECODE)[1]','int') as 'PERSONDETAILTYPECODE',
        T.c.value('(@TEXTVALUE)[1]','nvarchar(max)') as'TEXTVALUE',
        case
            when T.c.value('(@REGISTRATIONINFORMATIONOPTIONID)[1]','nvarchar(36)') = '' then null
            else T.c.value('(@REGISTRATIONINFORMATIONOPTIONID)[1]','uniqueidentifier') 
        end as 'REGISTRATIONINFORMATIONOPTIONID',
        T.c.value('(@REQUIRED)[1]','bit') as 'REQUIRED'
    from @REGISTRANTREGISTRATIONINFORMATION.nodes('/REGISTRANTREGISTRATIONINFORMATION/ITEM') T(c)
)