USP_SIMPLEDATALIST_MKTSEGMENTGROUPRECORDSOURCES

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTSEGMENTGROUPRECORDSOURCES]
(
  @SEGMENTGROUPID uniqueidentifier
)
as
  set nocount on;

  select distinct
    [MKTSEGMENT].[QUERYVIEWCATALOGID] as [VALUE],
    [QUERYVIEWCATALOG].[DISPLAYNAME] as [LABEL]
  from dbo.[MKTSEGMENT]
  inner join dbo.[MKTGROUPSEGMENTS] on [MKTGROUPSEGMENTS].[SEGMENTID] = [MKTSEGMENT].[ID]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
  where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = @SEGMENTGROUPID
  order by [QUERYVIEWCATALOG].[DISPLAYNAME];

  return 0;