USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETDYNAMICSELECTIONS

create procedure dbo.[USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETDYNAMICSELECTIONS]
(
  @ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier
)
as
  set nocount on;

  --Find any selections in the marketing acknowledgement's rules that use dynamic selections...

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

  union

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

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

  return 0;