USP_DATALIST_MKTSEGMENTATIONEXCLUSION

Display information about remove members process by marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



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

  select 
    [ID],
    [SELECTIONNAME],
    [FILENAME],
    [ORIGINALQUANTITY],
    [DELETEDQUANTITY],
    [ORIGINALQUANTITY]-[DELETEDQUANTITY] as [RESULTQUANTITY],
    [EXCEPTIONQUANTITY]
  from dbo.[MKTSEGMENTATIONEXCLUSION]
  where SEGMENTATIONID = @SEGMENTATIONID;

  return 0;