UFN_MEMBERSHIPDUESBATCH_GETCHILDREN_FROMITEMLISTXML

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETCHILDREN_FROMITEMLISTXML
(
    @CHILDREN xml
)
returns table
as
return (
    select
        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
        T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
        T.c.value('(RELATIONTOPRIMARY)[1]','nvarchar(100)') AS 'RELATIONTOPRIMARY',
        T.c.value('(AGE)[1]','nvarchar(20)') AS 'AGE'
    from @CHILDREN.nodes('/EXISTINGCHILDREN/ITEM') T(c)
)