USP_BUSINESSPROCESSSTATUS_UPDATENUMBERS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NUMBERPROCESSED	int	IN
@NUMBEROFEXCEPTIONS	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_BUSINESSPROCESSSTATUS_UPDATENUMBERS
(
  @ID uniqueidentifier,
  @NUMBERPROCESSED int,
  @NUMBEROFEXCEPTIONS int,
  @CHANGEAGENTID uniqueidentifier
)
as
begin
    if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  update dbo.BUSINESSPROCESSSTATUS
  set NUMBERPROCESSED = @NUMBERPROCESSED, NUMBEROFEXCEPTIONS = @NUMBEROFEXCEPTIONS, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = GetDate()
    where ID = @ID
end