USP_DATALIST_EVENTHOLDLIST

      CREATE procedure dbo.USP_DATALIST_EVENTHOLDLIST
      ( @CONTEXTID uniqueidentifier )
      as
          set nocount on;

        select
          EVENTHOLD.ID,
          EVENTHOLD.EVENTHOLDLISTID,
          HOLDCODE.DESCRIPTION,
          QUANTITY
        from
          dbo.EVENTHOLD
        inner join dbo.HOLDCODE on
          HOLDCODE.ID = EVENTHOLD.HOLDCODEID
        left join EVENTHOLDLIST on
          EVENTHOLD.EVENTHOLDLISTID = EVENTHOLDLIST.ID
        where 
          EVENTHOLDLIST.EVENTID = @CONTEXTID