USP_BATCH_SETSTATUS

Sets a batch to a certain status.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@STATUSCODE	tinyint	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_BATCH_SETSTATUS(
                @ID uniqueidentifier,
                @STATUSCODE tinyint,
                @CHANGEAGENTID uniqueidentifier
            ) as 
                set nocount on;

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

                update dbo.BATCH set 
                    STATUSCODE = @STATUSCODE,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = getdate()
                where
                    ID=@ID;

                return 0;