USP_DATALIST_MKTSEGMENTLISTBYSELECTION

A datalist of list segments based off selections from an already imported list segment.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@SEGMENTCATEGORYCODEID	uniqueidentifier	IN	Category

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTSEGMENTLISTBYSELECTION]
(
  @SEGMENTID uniqueidentifier,
  @SEGMENTCATEGORYCODEID uniqueidentifier = null
)
as
  set nocount on;

  select 
    [MKTSEGMENT].[ID] as [SEGMENTID],
    [MKTSEGMENT].[NAME] as [SEGMENTNAME],
    [MKTSEGMENTCATEGORYCODE].[DESCRIPTION] as [CATEGORY],
    [MKTSEGMENT].[CODE],
    [MKTSEGMENT].[DESCRIPTION],
    dbo.[UFN_MKTSEGMENT_ISINUSE]([MKTSEGMENT].[ID]) as [INUSE],
    [MKTSEGMENTLIST].[TOTALRECORDCOUNT] as [NUMROWS],
    [MKTSEGMENTREFRESHPROCESS].[ID] as [SEGMENTREFRESHPROCESSID]
  from dbo.[MKTSEGMENT]
  inner join dbo.[MKTSEGMENTLIST] ON [MKTSEGMENT].[CURRENTSEGMENTLISTID] = [MKTSEGMENTLIST].[ID]
  inner join dbo.[MKTSEGMENTREFRESHPROCESS] on [MKTSEGMENTREFRESHPROCESS].[SEGMENTID] = [MKTSEGMENT].[ID]
  left join dbo.[MKTSEGMENTCATEGORYCODE] on [MKTSEGMENTCATEGORYCODE].[ID] = [MKTSEGMENT].[SEGMENTCATEGORYCODEID]
  where [MKTSEGMENTLIST].[PARENTSEGMENTID] = @SEGMENTID
  and (@SEGMENTCATEGORYCODEID is null or [MKTSEGMENT].[SEGMENTCATEGORYCODEID] = @SEGMENTCATEGORYCODEID)
  order by [MKTSEGMENT].[NAME];

  return 0;