UFN_MEMBERSHIP_GETMEMBERSHIPCARDS_FROMITEMLISTXML

        create function [dbo].[UFN_MEMBERSHIP_GETMEMBERSHIPCARDS_FROMITEMLISTXML](@ITEMLISTXML xml) 
        returns table as
            return 
            (
                select
                    T2.cards.value('(ID)[1]','uniqueidentifier') AS 'ID',
                    T2.cards.value('(NAMEONCARD)[1]','nvarchar(700)') as 'NAMEONCARD',
                    T2.cards.value('(EXPIRATIONDATE)[1]','datetime') AS 'EXPIRATIONDATE',
                    T.members.value('(ID)[1]','uniqueidentifier') as 'MEMBERID'
                from 
                    @ITEMLISTXML.nodes('/MEMBERS/ITEM') T(members)
                cross apply
                    T.members.nodes('./MEMBERSHIPCARDS/ITEM') T2(cards)
            )