USP_DATALIST_MKTSEGMENTATION_BRIEFS

Displays a list of all marketing plan selection briefs for a marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@MINIMUMSEQUENCE	int	IN	Minimum sequence to refresh

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTSEGMENTATION_BRIEFS]
(
  @SEGMENTATIONID uniqueidentifier,
  @MINIMUMSEQUENCE int = null
)
as
  set nocount on;

  if @MINIMUMSEQUENCE is null
    set @MINIMUMSEQUENCE = 0;

  select 
    [MPB].[ID],
    [MPB].[SEQUENCE],
    [MPB].[NAME],
    [MPB].[COLLAPSED],
    [MPB].[BASECURRENCYID],
    [MPB].[TSLONG]
  from dbo.[MKTSEGMENTATION]
  inner join dbo.[MKTMARKETINGPLANBRIEF] as [MPB] on [MPB].[MARKETINGPLANITEMID] = [MKTSEGMENTATION].[MARKETINGPLANITEMID]
  where [MKTSEGMENTATION].[ID] = @SEGMENTATIONID
  and [MPB].[SEQUENCE] >= @MINIMUMSEQUENCE
  order by [MPB].[SEQUENCE];

  return 0;