UFN_ORDERDELIVERYMETHOD_GETREQUIREDFIELDS

      create function dbo.UFN_ORDERDELIVERYMETHOD_GETREQUIREDFIELDS()
      returns table as

      return select
        ID,
        NAMEREQUIRED,
        ADDRESSREQUIRED,
        PHONEREQUIRED,
        EMAILREQUIRED
      from dbo.DELIVERYMETHOD
      group by
        ID,
        NAMEREQUIRED,
        ADDRESSREQUIRED,
        PHONEREQUIRED,
        EMAILREQUIRED