UFN_REVENUEBATCH_GETMEMBERSHIP_FROMITEMLISTXML

        create function dbo.UFN_REVENUEBATCH_GETMEMBERSHIP_FROMITEMLISTXML(@ITEMLISTXML xml) returns table as
            return (
            select
                T.c.value('(MEMBERSHIPPROGRAMID)[1]','uniqueidentifier') as MEMBERSHIPPROGRAMID,
                T.c.value('(MEMBERSHIPLEVELID)[1]','uniqueidentifier') as MEMBERSHIPLEVELID,
                T.c.value('(MEMBERSHIPLEVELTERMID)[1]','uniqueidentifier') as MEMBERSHIPLEVELTERMID,
                T.c.value('(MEMBERSHIPTYPECODEID)[1]','uniqueidentifier') as MEMBERSHIPLEVELTYPECODEID,
                T.c.value('(NUMBEROFCHILDREN)[1]','tinyint') as NUMBEROFCHILDREN,
                T.c.value('(COMMENTS)[1]','nvarchar(1000)') as COMMENTS,
                T.c.value('(ISGIFT)[1]','bit') as ISGIFT,
                T.c.value('(SENDRENEWALCODE)[1]','tinyint') as SENDRENEWALCODE,
                T.c.value('(EXPIRATIONDATE)[1]','datetime') as EXPIRATIONDATE,
                T.c.value('(GIVENBYID)[1]','uniqueidentifier') as GIVENBYID,
                T.c.query('./MEMBERS') as MEMBERS
            from @ITEMLISTXML.nodes('/MEMBERSHIPS/ITEM') T(c)
              )