USP_DATALIST_MKTTESTSEGMENTATION

Displays a list of all test marketing efforts.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MKTTESTSEGMENTATION
(
  @SEGMENTATIONID uniqueidentifier,
  @ACTIVESTATUS bit = null
)
as
  set nocount on;

  select 
    S.[ID],
    S.[NAME],
    T.[ID],
    T.[IDINTEGER],
    T.[CODE],
    T.[NAME],
    T.[DESCRIPTION],
    dbo.[UFN_MKTMARKETINGPLANITEM_PATH](M.[ID],1),
    T.[ACTIVE],
    S.[MARKETINGPLANITEMID],
    T.[SOURCECODEID]
  from dbo.[MKTSEGMENTATION] T
  inner join dbo.[MKTSEGMENTATION] S on T.[PARENTSEGMENTATIONID]=S.[ID]
  left join dbo.[MKTMARKETINGPLANITEM] M on S.[MARKETINGPLANITEMID]=M.[ID]
  where (T.[PARENTSEGMENTATIONID]=@SEGMENTATIONID)
  and (@ACTIVESTATUS is null or @ACTIVESTATUS = T.[ACTIVE])
  order by S.[NAME];

  return 0;