USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_2
USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_2
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | nvarchar(max) | 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. |
@ASKLADDER | xml | IN | Ask ladder |
@ASKLADDERLOADED | bit | IN | Ask ladder loaded |
@PACKAGEID | uniqueidentifier | IN | Package |
@PACKAGECODE | nvarchar(10) | IN | Package code |
@PACKAGELOADED | bit | IN | Package loaded |
@RESPONSERATE | decimal(5, 2) | IN | Response rate |
@RESPONSERATELOADED | bit | IN | Response rate loaded |
@GIFTAMOUNT | money | IN | Gift amount |
@GIFTAMOUNTLOADED | bit | IN | Gift amount loaded |
@PACKAGECODEVALUEID | uniqueidentifier | IN | Package code value ID |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_2]
(
@ID nvarchar(max),
@CHANGEAGENTID uniqueidentifier = null,
@ASKLADDER xml,
@ASKLADDERLOADED bit,
@PACKAGEID uniqueidentifier,
@PACKAGECODE nvarchar(10),
@PACKAGELOADED bit,
@RESPONSERATE decimal(5,2),
@RESPONSERATELOADED bit,
@GIFTAMOUNT money,
@GIFTAMOUNTLOADED bit,
@PACKAGECODEVALUEID uniqueidentifier
)
as
set nocount on;
exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_3]
@ID,
@CHANGEAGENTID,
@ASKLADDER,
@ASKLADDERLOADED,
@PACKAGEID,
@PACKAGECODE,
@PACKAGELOADED,
@RESPONSERATE,
@RESPONSERATELOADED,
@GIFTAMOUNT,
@GIFTAMOUNTLOADED,
@PACKAGECODEVALUEID,
null;
return 0;