USP_BATCHCOMMIT_UPDATESTATUS

            create procedure dbo.USP_BATCHCOMMIT_UPDATESTATUS
            (@ID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
            as
            begin
                set nocount on;

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

                update dbo.BATCH set STATUSCODE = 1, DATECOMMITTED = GetDate(), CHANGEDBYID = @CHANGEAGENTID where ID = @ID;

                return 0;
            end