USP_SIMPLEDATALIST_PROGRAMLOCATION

      CREATE procedure dbo.USP_SIMPLEDATALIST_PROGRAMLOCATION 
     ( @PROGRAMID uniqueidentifier )
      as
      set nocount on;
          select 
              EVENTLOCATIONID as VALUE, 
              EVENTLOCATION.NAME as LABEL
          from dbo.PROGRAMLOCATION
        inner join dbo.EVENTLOCATION on
          EVENTLOCATION.ID = PROGRAMLOCATION.EVENTLOCATIONID
          where PROGRAMLOCATION.PROGRAMID = @PROGRAMID;