USP_BUSINESSPROCESSOUPUT_ADDOUTPUTTABLE

Adds a business process output record.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@TABLENAME	nvarchar(128)	IN
@TABLEKEY	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@COLUMNMETADATA	xml	IN
@EXPORTCOLUMNMETADATA	xml	IN
@MARTKEY	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_BUSINESSPROCESSOUPUT_ADDOUTPUTTABLE]
(
    @ID uniqueidentifier,
    @BUSINESSPROCESSSTATUSID uniqueidentifier,                
    @TABLENAME nvarchar(128),
    @TABLEKEY nvarchar(50),
    @CHANGEAGENTID uniqueidentifier,
    @COLUMNMETADATA xml = null,
    @EXPORTCOLUMNMETADATA xml = null,
  @MARTKEY nvarchar(255) = ''
)
with execute as caller                
as
begin
    set nocount on

    declare @CURRENTDATE datetime;

    set @CURRENTDATE = getdate();

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

    insert into dbo.[BUSINESSPROCESSOUTPUT]
    (
    [ID],
    [BUSINESSPROCESSSTATUSID],
    [TABLENAME],
    [TABLEKEY],
    [DOWNLOADPARAMETERS],
    [COLUMNMETADATA],
    [MARTKEY],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED],
    [EXPORTCOLUMNMETADATA]
  ) values (
    @ID,
    @BUSINESSPROCESSSTATUSID,
    @TABLENAME,
    @TABLEKEY,
    '',
    @COLUMNMETADATA,
    @MARTKEY,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE,
    @EXPORTCOLUMNMETADATA
  )
end