USP_HTMLTEMPLATETODOCXMERGEPROCESS_SAVE

Saves a parameter set record for the HTML Template to Docx Merge business process.

Parameters

Parameter	Parameter Type	Mode
@MKTSEGMENTATIONEXPORTPROCESSSTATUSID	uniqueidentifier	IN
@NAME	nvarchar(256)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_HTMLTEMPLATETODOCXMERGEPROCESS_SAVE
(
    @MKTSEGMENTATIONEXPORTPROCESSSTATUSID uniqueidentifier,
    @NAME nvarchar(256),
    @CHANGEAGENTID uniqueidentifier = null,
    @ID uniqueidentifier output
)
as
begin

    set nocount on;

    declare @CURRENTDATE datetime;

    begin try
    if @CHANGEAGENTID is null  
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

    set @ID = null;

    select 
        @ID = ID 
    from 
        HTMLTEMPLATETODOCXMERGEPROCESS 
    where 
        MKTSEGMENTATIONEXPORTPROCESSSTATUSID = @MKTSEGMENTATIONEXPORTPROCESSSTATUSID

    if @ID is null
    begin
            set @ID = newid();
            insert into dbo.[HTMLTEMPLATETODOCXMERGEPROCESS] (
              [ID],
              [NAME],
              [MKTSEGMENTATIONEXPORTPROCESSSTATUSID],
              [ADDEDBYID],
              [CHANGEDBYID],
              [DATEADDED],
              [DATECHANGED]
            ) values (
              @ID,
              @NAME,
              @MKTSEGMENTATIONEXPORTPROCESSSTATUSID,
              @CHANGEAGENTID,
              @CHANGEAGENTID,
              @CURRENTDATE,
              @CURRENTDATE
            );
    end

    end try

    begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
    end catch

    return 0;

end