UFN_MEMBERSHIP_GETMEMBERSHIPCARDCOUNT_FROMITEMLISTXML

            CREATE function [dbo].[UFN_MEMBERSHIP_GETMEMBERSHIPCARDCOUNT_FROMITEMLISTXML](@ITEMLISTXML xml) 
            returns smallint with execute as caller
            as
                begin
                        declare @CARDCOUNT smallint
                        select @CARDCOUNT = count(T2.cards.value('(ID)[1]','uniqueidentifier'))
                        from @ITEMLISTXML.nodes('/MEMBERS/ITEM') T(members)
                        cross apply    T.members.nodes('./MEMBERSHIPCARDS/ITEM') T2(cards)

                        return @CARDCOUNT
                end