USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANBRIEF

The load procedure used by the edit dataform template "Marketing Plan Segment Summary Add Form"

Parameters

Parameter Parameter Type Mode Description
@MARKETINGPLANITEMID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@MARKETINGPLANID uniqueidentifier INOUT Marketing plan

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANBRIEF]
(
  @MARKETINGPLANITEMID uniqueidentifier,
  @MARKETINGPLANID uniqueidentifier = null output
)
as
  set nocount on;

  select
    @MARKETINGPLANID = MARKETINGPLANID
  from dbo.[MKTMARKETINGPLANITEM]
  where [ID] = @MARKETINGPLANITEMID;

  return 0;