USP_SIMPLEDATALIST_MKTVENDOR

CREATE procedure dbo.USP_SIMPLEDATALIST_MKTVENDOR
as
  set nocount on;

  select 
    [VENDOR].[ID] as [VALUE], 
    [CONSTITUENT].[NAME] as [LABEL] 
  from 
    dbo.[VENDOR]
  inner join
    dbo.[CONSTITUENT] on [VENDOR].[ID] = [CONSTITUENT].[ID]
  order by [CONSTITUENT].[KEYNAME];

  return 0;