UFN_REVENUEBATCH_GETMEMBERSHIPMEMBERSWITHCHILDREN_FROMITEMLISTXML

            create function dbo.UFN_REVENUEBATCH_GETMEMBERSHIPMEMBERSWITHCHILDREN_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            )
            returns table
            as return
            (
                select
                    T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',  
                    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',  
                    T.c.value('(ISPRIMARY)[1]','bit') AS 'ISPRIMARY',  
                    case when T.c.exist('./MEMBERSHIPCARDS/ITEM') = 1 then T.c.query('(MEMBERSHIPCARDS)[1]') else null end as 'MEMBERSHIPCARDS'
                from @ITEMLISTXML.nodes('/MEMBERS/ITEM') T(c)
            )