USP_MKTSEGMENTATION_EXCLUSIONS_GETOPTIONS

Retrieves information about a marketing effort exclusions process parameter set.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATION_EXCLUSIONS_GETOPTIONS]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select 
    [MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID] as [SEGMENTATIONID],
    dbo.[UFN_MKTSEGMENTATION_ISCALCULATING]([MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID]) as [ISCALCULATING],
    dbo.[UFN_MKTSEGMENTATION_ISACTIVATING]([MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID]) as [ISACTIVATING],
    dbo.[UFN_MKTSEGMENTATION_ISRECORDCOUNTCACHECURRENT]([MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID], 0) as [RECORDCOUNTCACHEISCURRENT],
    [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID] as [SEGMENTATIONSEGMENTCALCULATEPROCESSID],
    [MKTSEGMENTATION].[MAILINGTYPECODE]
  from dbo.[MKTSEGMENTATIONEXCLUSIONSPROCESS]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID]
  left outer join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  where [MKTSEGMENTATIONEXCLUSIONSPROCESS].[ID] = @ID;

  return 0;