USP_SIMPLEDATALIST_MKTSEGMENTATIONVENDOR

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTSEGMENTATIONVENDOR]
(
  @SEGMENTATIONID uniqueidentifier = null
)
as
  set nocount on;

  select distinct
    [L].[VENDORID] as [VALUE], 
    [C].[KEYNAME] as [LABEL]
  from dbo.[MKTSEGMENTATIONSEGMENT] as [SS] 
  inner join dbo.[MKTSEGMENT] as [S] on [S].[ID] = [SS].[SEGMENTID]
  inner join dbo.[MKTSEGMENTLIST] as [SL] on [SL].[ID] = [S].[CURRENTSEGMENTLISTID] and [SL].[TYPECODE] = 1 
  inner join dbo.[MKTLIST] as [L] on [L].[ID] = [SL].[LISTID]
  inner join dbo.[CONSTITUENT] as [C] on [C].[ID] = [L].[VENDORID]
  where [SS].[SEGMENTATIONID] = @SEGMENTATIONID or @SEGMENTATIONID is null

  union all

  select
    '00000000-0000-0000-0000-000000000001' as [VALUE], 
    '<House file>' as [LABEL]

  return 0;