UFN_MEMBERSHIPDUESBATCH_GETMEMBERS_FROMITEMLISTXML

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERS_FROMITEMLISTXML
(
    @MEMBERS 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('(LOOKUPID)[1]','nvarchar(100)') AS 'LOOKUPID'
    from @MEMBERS.nodes('/EXISTINGMEMBERS/ITEM') T(c)
)