USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONTESTSEGMENT_3

Procedure used for editing a test segment. Includes ask ladders.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@CODE	nvarchar(10)	IN	Code
@TESTSEGMENTCODE	nvarchar(10)	IN	Test segment
@PACKAGEID	uniqueidentifier	IN	Package
@PACKAGECODE	nvarchar(10)	IN	Package code
@RESPONSERATE	decimal(5, 2)	IN	Response rate
@GIFTAMOUNT	money	IN	Gift amount
@SAMPLESIZE	int	IN	Sample size
@SAMPLESIZETYPECODE	tinyint	IN	Sample size type
@SAMPLESIZEMETHODCODE	tinyint	IN	Sample size method
@ASKLADDERID	uniqueidentifier	IN	Ask ladder
@PREFIXCODE	tinyint	IN	Prepend list
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@TESTSEGMENTCODEVALUEID	uniqueidentifier	IN	Test segment code value ID
@PACKAGECODEVALUEID	uniqueidentifier	IN	Package code value ID
@ITEMLIST	xml	IN	Items
@CHANNELSOURCECODE	nvarchar(10)	IN	Channel source code
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN	Channel code value ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONTESTSEGMENT_3]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @CODE nvarchar(10),
  @TESTSEGMENTCODE nvarchar(10),
  @PACKAGEID uniqueidentifier,
  @PACKAGECODE nvarchar(10),
  @RESPONSERATE decimal(5,2),
  @GIFTAMOUNT money,
  @SAMPLESIZE int,
  @SAMPLESIZETYPECODE tinyint,
  @SAMPLESIZEMETHODCODE tinyint,
  @ASKLADDERID uniqueidentifier,
  @PREFIXCODE tinyint,
  @CODEVALUEID uniqueidentifier,
  @TESTSEGMENTCODEVALUEID uniqueidentifier,
  @PACKAGECODEVALUEID uniqueidentifier,
  @ITEMLIST xml,
  @CHANNELSOURCECODE nvarchar(10),
  @CHANNELSOURCECODEVALUEID uniqueidentifier
)
as
  set nocount on;

  declare @FRACTION nvarchar(10);

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONTESTSEGMENT_3]
    @ID = @ID,
    @FRACTION = @FRACTION output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONTESTSEGMENT_4]
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @DESCRIPTION,
    @CODE,
    @TESTSEGMENTCODE,
    @PACKAGEID,
    @PACKAGECODE,
    @RESPONSERATE,
    @GIFTAMOUNT,
    @SAMPLESIZE,
    @SAMPLESIZETYPECODE,
    @SAMPLESIZEMETHODCODE,
    @ASKLADDERID,
    @PREFIXCODE,
    @CODEVALUEID,
    @TESTSEGMENTCODEVALUEID,
    @PACKAGECODEVALUEID,
    @ITEMLIST,
    @CHANNELSOURCECODE,
    @CHANNELSOURCECODEVALUEID,
    @FRACTION;

  return 0;