UFN_MEMBERSHIPPROGRAMS_FROMITEMLISTXML

        create function BBDW.[UFN_MEMBERSHIPPROGRAMS_FROMITEMLISTXML](
            @ITEMLISTXML xml
        )
        returns table  as
          return (
              select
                  T.c.value('(MEMBERSHIPPROGRAMID)[1]', 'nvarchar(50)') as 'MEMBERSHIPPROGRAMID',
                  T.c.value('(INCLUDE)[1]', 'bit') as 'INCLUDE'
              from @ITEMLISTXML.nodes('/MEMBERSHIPPROGRAMS/ITEM') T(c)
          )