USP_DATALIST_HOLDLIST

      CREATE procedure dbo.USP_DATALIST_HOLDLIST

      as
          set nocount on;

          select 
          HOLDLIST.ID,
              NAME,
          null,
          null,
          null,
          1,
          0
          from 
          dbo.HOLDLIST

        union all

        select
          HOLD.ID,
          null,
          HOLDLISTID,
          HOLDCODE.DESCRIPTION,
          QUANTITY,
          0,
          1
        from
          dbo.HOLD
        inner join dbo.HOLDCODE on
          HOLDCODE.ID = HOLD.HOLDCODEID
        order by NAME