USP_MKTSEGMENTATIONSEGMENTCALCULATEPROCESS_GETDYNAMICSELECTIONS

create procedure dbo.[USP_MKTSEGMENTATIONSEGMENTCALCULATEPROCESS_GETDYNAMICSELECTIONS]
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

  --Find any selections in the mailing's segments that use dynamic selections...

  select
    [IDSETREGISTER].[NAME]
  from dbo.[MKTSEGMENTATIONSEGMENT]
  inner join dbo.[MKTSEGMENTSELECTION] on [MKTSEGMENTSELECTION].[SEGMENTID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
  inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENTSELECTION].[SELECTIONID]
  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
  and [IDSETREGISTER].[STATIC] = 0

  union

  --Find any selections in the mailing's universe/exclusion filters that use dynamic selections...

  select
    [IDSETREGISTER].[NAME]
  from dbo.[MKTSEGMENTATIONFILTERSELECTION]
  inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENTATIONFILTERSELECTION].[SELECTIONID]
  where [MKTSEGMENTATIONFILTERSELECTION].[SEGMENTATIONID] = @SEGMENTATIONID
  and [IDSETREGISTER].[STATIC] = 0
  order by [NAME];

  return 0;