USP_SIMPLEDATALIST_MKTSEGMENTATIONEXCLUSION

Displays all process dates for the removed members process of a marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Effort ID

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_MKTSEGMENTATIONEXCLUSION
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

  select  
    [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[ID] as VALUE, 
    [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[DATEADDED] as LABEL
  from 
    dbo.[MKTSEGMENTATIONEXCLUSION]
    inner join dbo.[MKTUPDATEMAILINGCOUNTSPROCESSSTATUS] on [MKTSEGMENTATIONEXCLUSION].[STATUSID] = [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[ID]
  where
    [MKTSEGMENTATIONEXCLUSION].[SEGMENTATIONID] = @SEGMENTATIONID
  order by 
    [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[DATEADDED] desc;

  return 0;