Try it

Paste a T-SQL CREATE PROCEDURE/ALTER PROCEDURE body below. The demo is rate-limited and capped at 20,000 characters / 500 lines — subscribe for unlimited use via the API or your account's playground.

SQL

CREATE PROCEDURE dbo.ProcessPendingOrders
    @minOrderTotal DECIMAL(10,2),
    @maxOrdersToProcess INT
AS
BEGIN
    IF @maxOrdersToProcess <= 0
    BEGIN
        RAISERROR('maxOrdersToProcess must be greater than zero', 16, 1);
    END

DECLARE @processedCount INT = 0;
    DECLARE @currentOrderId INT;

WHILE @processedCount < @maxOrdersToProcess
    BEGIN
        SELECT TOP 1 @currentOrderId = o.Id
        FROM Orders o
        JOIN Customers c ON o.CustomerId = c.Id
        WHERE o.Status = 'Pending'
          AND o.Total >= @minOrderTotal
        ORDER BY o.CreatedAt;

IF @currentOrderId IS NULL
        BEGIN
            BREAK;
        END

IF EXISTS (SELECT 1 FROM FraudFlags WHERE OrderId = @currentOrderId)
        BEGIN
            SET @processedCount = @processedCount + 1;
            CONTINUE;
        END

BEGIN TRANSACTION;

IF @minOrderTotal > 1000 AND @maxOrdersToProcess < 10 OR NOT (@processedCount = 0)
        BEGIN
            UPDATE Orders
            SET Total = (SELECT MAX(Total) FROM ArchivedOrders WHERE ArchivedOrders.CustomerId = Orders.CustomerId)
            WHERE Id = @currentOrderId;

ROLLBACK TRANSACTION;
        END
        ELSE
        BEGIN
            UPDATE Orders
            SET Status = 'Processed'
            WHERE Id = @currentOrderId;

INSERT INTO OrderAudit (OrderId, Action)
            VALUES (@currentOrderId, 'Processed');

COMMIT TRANSACTION;

EXEC dbo.NotifyOrderProcessed @currentOrderId;
        END

SET @processedCount = @processedCount + 1;
    END

DELETE FROM OrderAudit WHERE CreatedAt < DATEADD(YEAR, -1, GETDATE());
END