USP_MKTSEGMENTATIONEXCLUSION_GETSEGMENTATION

Gets the marketing effort for a remove members process.

Parameters

Parameter	Parameter Type	Mode	Description
@STATUSID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTSEGMENTATIONEXCLUSION_GETSEGMENTATION
(
  @STATUSID uniqueidentifier 
)
as
  set nocount on;

  select
    [ID] as [SEGMENTATIONEXCLUSIONID],
    [SEGMENTATIONID],
    [STATUSID]
  from dbo.[MKTSEGMENTATIONEXCLUSION]
  where [STATUSID] = @STATUSID;  

  return 0;