USP_QUEUEPROCESS_ADDRESULTS

Adds a row to the QUEUEPROCESSRESULT table.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@STEPNUMBER	int	IN
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@PARAMETERSETID	uniqueidentifier	IN
@COMPLETIONCODE	tinyint	IN
@COMPLETIONMESSAGE	nvarchar(1000)	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_QUEUEPROCESS_ADDRESULTS
            (
                @ID uniqueidentifier = null output,
                @STEPNUMBER int = 0,
                @BUSINESSPROCESSCATALOGID uniqueidentifier,
                @PARAMETERSETID uniqueidentifier = null,
                @COMPLETIONCODE tinyint = 0,
                @COMPLETIONMESSAGE nvarchar(1000) = '',
                @STARTDATE datetime,
                @ENDDATE datetime,
                @BUSINESSPROCESSSTATUSID uniqueidentifier
            )
            as 
            begin
                set nocount on;

                if @ID is null set @ID = newid();

                insert into 
                    dbo.QUEUEPROCESSRESULT (ID, STEPNUMBER, BUSINESSPROCESSCATALOGID, PARAMETERSETID, COMPLETIONCODE, COMPLETIONMESSAGE, STARTDATE, ENDDATE, BUSINESSPROCESSSTATUSID)
                values
                    (@ID, @STEPNUMBER, @BUSINESSPROCESSCATALOGID, @PARAMETERSETID, @COMPLETIONCODE, @COMPLETIONMESSAGE, @STARTDATE, @ENDDATE, @BUSINESSPROCESSSTATUSID)
            end