SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.Stack
(
    StackID integer NOT NULL PRIMARY KEY,
    Crates varchar(8000) COLLATE Latin1_General_BIN2 NOT NULL
);

CREATE TABLE dbo.Rearrangement
(
    StepID integer IDENTITY NOT NULL PRIMARY KEY,
    Operation varchar(8000) NOT NULL
);
INSERT dbo.Stack
    (StackID, Crates)
VALUES
    (1, 'DTWFJSHN'),
    (2, 'HRPQTNBG'),
    (3, 'LQV'),
    (4, 'NBSWRQ'),
    (5, 'NDFTVMB'),
    (6, 'MDBVHTR'),
    (7, 'DBQJ'),
    (8, 'DNJVRZHQ'),
    (9, 'BNHMS');

INSERT dbo.Rearrangement
    (Operation)
VALUES
    ('move 3 from 1 to 2'),
    ('move 1 from 7 to 1'),
    ('move 1 from 6 to 5'),
    ('move 5 from 5 to 9'),
    ('move 2 from 5 to 2'),
    ('move 1 from 6 to 8'),
    ('move 1 from 5 to 7'),
    ('move 5 from 4 to 6'),
    ('move 1 from 7 to 6'),
    ('move 1 from 2 to 4'),
    ('move 5 from 2 to 6'),
    ('move 2 from 1 to 5'),
    ('move 2 from 1 to 9'),
    ('move 16 from 6 to 4'),
    ('move 6 from 8 to 3'),
    ('move 7 from 2 to 4'),
    ('move 5 from 9 to 3'),
    ('move 1 from 1 to 4'),
    ('move 1 from 1 to 3'),
    ('move 3 from 7 to 4'),
    ('move 2 from 5 to 4'),
    ('move 31 from 4 to 8'),
    ('move 22 from 8 to 4'),
    ('move 9 from 3 to 6'),
    ('move 7 from 9 to 5'),
    ('move 4 from 5 to 6'),
    ('move 6 from 3 to 2'),
    ('move 2 from 6 to 7'),
    ('move 5 from 2 to 7'),
    ('move 1 from 2 to 4'),
    ('move 1 from 7 to 5'),
    ('move 4 from 5 to 4'),
    ('move 2 from 6 to 9'),
    ('move 2 from 4 to 6'),
    ('move 7 from 6 to 4'),
    ('move 2 from 6 to 1'),
    ('move 1 from 6 to 8'),
    ('move 8 from 8 to 1'),
    ('move 1 from 7 to 6'),
    ('move 4 from 1 to 5'),
    ('move 9 from 4 to 8'),
    ('move 4 from 1 to 7'),
    ('move 3 from 5 to 3'),
    ('move 2 from 1 to 9'),
    ('move 1 from 3 to 2'),
    ('move 1 from 9 to 8'),
    ('move 1 from 2 to 1'),
    ('move 1 from 1 to 8'),
    ('move 1 from 5 to 1'),
    ('move 2 from 3 to 1'),
    ('move 2 from 6 to 9'),
    ('move 19 from 4 to 1'),
    ('move 4 from 4 to 2'),
    ('move 6 from 1 to 4'),
    ('move 1 from 2 to 4'),
    ('move 4 from 4 to 3'),
    ('move 7 from 7 to 3'),
    ('move 7 from 8 to 2'),
    ('move 2 from 7 to 4'),
    ('move 3 from 2 to 1'),
    ('move 8 from 8 to 2'),
    ('move 3 from 9 to 1'),
    ('move 2 from 9 to 1'),
    ('move 10 from 2 to 7'),
    ('move 4 from 3 to 1'),
    ('move 1 from 8 to 3'),
    ('move 1 from 4 to 5'),
    ('move 1 from 3 to 6'),
    ('move 1 from 2 to 1'),
    ('move 10 from 1 to 3'),
    ('move 1 from 4 to 7'),
    ('move 1 from 6 to 4'),
    ('move 7 from 3 to 2'),
    ('move 5 from 2 to 8'),
    ('move 11 from 7 to 2'),
    ('move 3 from 4 to 3'),
    ('move 1 from 4 to 3'),
    ('move 5 from 8 to 9'),
    ('move 17 from 2 to 4'),
    ('move 11 from 1 to 5'),
    ('move 4 from 1 to 3'),
    ('move 5 from 9 to 2'),
    ('move 4 from 2 to 1'),
    ('move 3 from 5 to 7'),
    ('move 6 from 5 to 3'),
    ('move 1 from 5 to 8'),
    ('move 6 from 1 to 8'),
    ('move 3 from 8 to 5'),
    ('move 1 from 1 to 4'),
    ('move 1 from 7 to 2'),
    ('move 15 from 3 to 4'),
    ('move 1 from 1 to 3'),
    ('move 10 from 3 to 9'),
    ('move 2 from 7 to 4'),
    ('move 1 from 2 to 8'),
    ('move 21 from 4 to 9'),
    ('move 1 from 2 to 3'),
    ('move 1 from 8 to 1'),
    ('move 9 from 4 to 2'),
    ('move 1 from 1 to 5'),
    ('move 5 from 2 to 7'),
    ('move 2 from 8 to 5'),
    ('move 1 from 8 to 1'),
    ('move 2 from 2 to 8'),
    ('move 2 from 4 to 9'),
    ('move 24 from 9 to 5'),
    ('move 3 from 4 to 1'),
    ('move 2 from 2 to 5'),
    ('move 12 from 5 to 1'),
    ('move 10 from 1 to 5'),
    ('move 23 from 5 to 6'),
    ('move 8 from 9 to 1'),
    ('move 3 from 8 to 1'),
    ('move 1 from 1 to 2'),
    ('move 1 from 3 to 7'),
    ('move 11 from 6 to 1'),
    ('move 1 from 2 to 4'),
    ('move 6 from 6 to 8'),
    ('move 4 from 6 to 7'),
    ('move 1 from 7 to 3'),
    ('move 1 from 3 to 4'),
    ('move 23 from 1 to 8'),
    ('move 1 from 4 to 2'),
    ('move 1 from 2 to 1'),
    ('move 1 from 6 to 7'),
    ('move 6 from 5 to 3'),
    ('move 1 from 7 to 8'),
    ('move 1 from 1 to 8'),
    ('move 1 from 9 to 3'),
    ('move 6 from 7 to 2'),
    ('move 3 from 5 to 9'),
    ('move 5 from 2 to 3'),
    ('move 28 from 8 to 3'),
    ('move 4 from 1 to 9'),
    ('move 5 from 9 to 5'),
    ('move 2 from 8 to 5'),
    ('move 1 from 9 to 4'),
    ('move 2 from 7 to 5'),
    ('move 1 from 4 to 2'),
    ('move 1 from 4 to 8'),
    ('move 2 from 8 to 3'),
    ('move 6 from 5 to 2'),
    ('move 1 from 7 to 2'),
    ('move 39 from 3 to 2'),
    ('move 2 from 3 to 8'),
    ('move 1 from 9 to 6'),
    ('move 2 from 2 to 9'),
    ('move 2 from 9 to 6'),
    ('move 1 from 8 to 1'),
    ('move 1 from 1 to 6'),
    ('move 5 from 6 to 9'),
    ('move 2 from 5 to 8'),
    ('move 20 from 2 to 4'),
    ('move 2 from 4 to 8'),
    ('move 2 from 8 to 3'),
    ('move 3 from 3 to 1'),
    ('move 22 from 2 to 5'),
    ('move 2 from 9 to 1'),
    ('move 3 from 1 to 7'),
    ('move 1 from 2 to 6'),
    ('move 1 from 2 to 9'),
    ('move 1 from 1 to 8'),
    ('move 2 from 7 to 9'),
    ('move 1 from 6 to 8'),
    ('move 1 from 2 to 7'),
    ('move 1 from 1 to 3'),
    ('move 1 from 9 to 8'),
    ('move 1 from 8 to 5'),
    ('move 3 from 8 to 7'),
    ('move 3 from 7 to 8'),
    ('move 15 from 4 to 1'),
    ('move 1 from 4 to 3'),
    ('move 10 from 1 to 6'),
    ('move 3 from 8 to 1'),
    ('move 5 from 9 to 4'),
    ('move 7 from 5 to 1'),
    ('move 4 from 6 to 3'),
    ('move 15 from 5 to 2'),
    ('move 4 from 6 to 4'),
    ('move 7 from 2 to 1'),
    ('move 6 from 4 to 6'),
    ('move 1 from 5 to 9'),
    ('move 1 from 5 to 7'),
    ('move 1 from 3 to 5'),
    ('move 11 from 1 to 8'),
    ('move 3 from 4 to 6'),
    ('move 4 from 1 to 5'),
    ('move 1 from 2 to 5'),
    ('move 2 from 8 to 3'),
    ('move 11 from 6 to 1'),
    ('move 1 from 3 to 7'),
    ('move 1 from 9 to 8'),
    ('move 6 from 5 to 8'),
    ('move 3 from 8 to 4'),
    ('move 1 from 4 to 5'),
    ('move 3 from 3 to 1'),
    ('move 9 from 8 to 2'),
    ('move 2 from 1 to 5'),
    ('move 11 from 2 to 5'),
    ('move 1 from 3 to 6'),
    ('move 2 from 8 to 5'),
    ('move 3 from 4 to 6'),
    ('move 1 from 8 to 3'),
    ('move 2 from 1 to 9'),
    ('move 1 from 3 to 8'),
    ('move 16 from 5 to 7'),
    ('move 3 from 1 to 6'),
    ('move 1 from 3 to 5'),
    ('move 1 from 6 to 7'),
    ('move 1 from 9 to 4'),
    ('move 1 from 5 to 4'),
    ('move 1 from 3 to 2'),
    ('move 1 from 1 to 2'),
    ('move 3 from 4 to 9'),
    ('move 1 from 2 to 7'),
    ('move 2 from 8 to 3'),
    ('move 6 from 2 to 8'),
    ('move 11 from 1 to 3'),
    ('move 6 from 3 to 1'),
    ('move 4 from 3 to 2'),
    ('move 2 from 3 to 1'),
    ('move 1 from 1 to 3'),
    ('move 4 from 8 to 4'),
    ('move 4 from 8 to 2'),
    ('move 11 from 7 to 2'),
    ('move 9 from 7 to 5'),
    ('move 1 from 7 to 3'),
    ('move 4 from 5 to 7'),
    ('move 14 from 2 to 3'),
    ('move 17 from 3 to 7'),
    ('move 2 from 5 to 2'),
    ('move 1 from 5 to 7'),
    ('move 1 from 5 to 6'),
    ('move 4 from 6 to 7'),
    ('move 8 from 1 to 2'),
    ('move 2 from 6 to 4'),
    ('move 1 from 6 to 8'),
    ('move 6 from 4 to 1'),
    ('move 1 from 8 to 5'),
    ('move 6 from 7 to 8'),
    ('move 5 from 8 to 3'),
    ('move 12 from 2 to 1'),
    ('move 1 from 8 to 4'),
    ('move 4 from 3 to 1'),
    ('move 4 from 2 to 4'),
    ('move 3 from 9 to 3'),
    ('move 3 from 3 to 2'),
    ('move 1 from 3 to 2'),
    ('move 3 from 4 to 1'),
    ('move 2 from 5 to 7'),
    ('move 22 from 1 to 8'),
    ('move 17 from 8 to 6'),
    ('move 21 from 7 to 6'),
    ('move 3 from 2 to 8'),
    ('move 3 from 1 to 5'),
    ('move 3 from 5 to 2'),
    ('move 2 from 4 to 6'),
    ('move 7 from 6 to 5'),
    ('move 1 from 9 to 4'),
    ('move 14 from 6 to 4'),
    ('move 5 from 8 to 3'),
    ('move 1 from 6 to 3'),
    ('move 3 from 3 to 9'),
    ('move 2 from 9 to 1'),
    ('move 2 from 7 to 1'),
    ('move 16 from 6 to 8'),
    ('move 2 from 6 to 7'),
    ('move 1 from 2 to 7'),
    ('move 1 from 3 to 8'),
    ('move 7 from 4 to 1'),
    ('move 2 from 7 to 2'),
    ('move 4 from 4 to 7'),
    ('move 5 from 2 to 4'),
    ('move 1 from 7 to 3'),
    ('move 3 from 5 to 8'),
    ('move 1 from 7 to 5'),
    ('move 12 from 1 to 6'),
    ('move 3 from 7 to 2'),
    ('move 7 from 4 to 2'),
    ('move 3 from 3 to 2'),
    ('move 1 from 4 to 2'),
    ('move 1 from 9 to 8'),
    ('move 8 from 6 to 8'),
    ('move 12 from 2 to 4'),
    ('move 5 from 5 to 2'),
    ('move 11 from 4 to 9'),
    ('move 3 from 6 to 3'),
    ('move 2 from 4 to 2'),
    ('move 4 from 2 to 6'),
    ('move 5 from 2 to 8'),
    ('move 12 from 8 to 4'),
    ('move 20 from 8 to 5'),
    ('move 13 from 5 to 3'),
    ('move 1 from 8 to 5'),
    ('move 5 from 5 to 9'),
    ('move 16 from 9 to 1'),
    ('move 9 from 4 to 5'),
    ('move 12 from 3 to 9'),
    ('move 5 from 6 to 5'),
    ('move 9 from 9 to 7'),
    ('move 14 from 1 to 4'),
    ('move 14 from 4 to 1'),
    ('move 15 from 5 to 7'),
    ('move 4 from 8 to 2'),
    ('move 3 from 4 to 3'),
    ('move 3 from 1 to 8'),
    ('move 1 from 5 to 9'),
    ('move 1 from 5 to 3'),
    ('move 3 from 9 to 8'),
    ('move 4 from 3 to 4'),
    ('move 1 from 4 to 6'),
    ('move 20 from 7 to 2'),
    ('move 2 from 3 to 8'),
    ('move 3 from 7 to 2'),
    ('move 4 from 2 to 1'),
    ('move 1 from 6 to 7'),
    ('move 3 from 4 to 2'),
    ('move 2 from 2 to 3'),
    ('move 4 from 3 to 4'),
    ('move 1 from 8 to 1'),
    ('move 3 from 8 to 1'),
    ('move 2 from 7 to 8'),
    ('move 1 from 4 to 5'),
    ('move 14 from 2 to 5'),
    ('move 6 from 1 to 5'),
    ('move 1 from 4 to 3'),
    ('move 15 from 1 to 4'),
    ('move 1 from 8 to 2'),
    ('move 1 from 9 to 5'),
    ('move 4 from 8 to 7'),
    ('move 13 from 5 to 6'),
    ('move 1 from 8 to 1'),
    ('move 2 from 7 to 9'),
    ('move 12 from 6 to 4'),
    ('move 1 from 3 to 6'),
    ('move 1 from 1 to 6'),
    ('move 4 from 5 to 2'),
    ('move 5 from 5 to 6'),
    ('move 2 from 6 to 2'),
    ('move 1 from 7 to 5'),
    ('move 2 from 6 to 9'),
    ('move 1 from 5 to 9'),
    ('move 16 from 2 to 5'),
    ('move 17 from 4 to 1'),
    ('move 3 from 1 to 3'),
    ('move 1 from 2 to 6'),
    ('move 2 from 6 to 1'),
    ('move 3 from 3 to 1'),
    ('move 14 from 1 to 8'),
    ('move 3 from 5 to 2'),
    ('move 4 from 8 to 2'),
    ('move 3 from 4 to 5'),
    ('move 15 from 5 to 3'),
    ('move 1 from 7 to 6'),
    ('move 3 from 1 to 8'),
    ('move 2 from 3 to 7'),
    ('move 1 from 1 to 2'),
    ('move 1 from 7 to 6'),
    ('move 4 from 2 to 8'),
    ('move 2 from 6 to 2'),
    ('move 1 from 7 to 6'),
    ('move 3 from 8 to 2'),
    ('move 12 from 8 to 6'),
    ('move 1 from 5 to 6'),
    ('move 3 from 2 to 5'),
    ('move 2 from 2 to 5'),
    ('move 4 from 6 to 5'),
    ('move 4 from 3 to 5'),
    ('move 1 from 8 to 4'),
    ('move 11 from 6 to 4'),
    ('move 6 from 3 to 1'),
    ('move 2 from 9 to 8'),
    ('move 20 from 4 to 5'),
    ('move 1 from 4 to 9'),
    ('move 2 from 3 to 8'),
    ('move 1 from 3 to 8'),
    ('move 17 from 5 to 8'),
    ('move 5 from 5 to 9'),
    ('move 9 from 5 to 1'),
    ('move 2 from 6 to 7'),
    ('move 23 from 8 to 2'),
    ('move 2 from 7 to 5'),
    ('move 3 from 9 to 4'),
    ('move 16 from 2 to 4'),
    ('move 11 from 1 to 8'),
    ('move 4 from 5 to 8'),
    ('move 11 from 2 to 6'),
    ('move 2 from 6 to 1'),
    ('move 5 from 9 to 5'),
    ('move 5 from 5 to 6'),
    ('move 5 from 8 to 6'),
    ('move 1 from 6 to 7'),
    ('move 7 from 8 to 1'),
    ('move 12 from 1 to 2'),
    ('move 1 from 9 to 5'),
    ('move 1 from 1 to 3'),
    ('move 1 from 1 to 4'),
    ('move 1 from 5 to 3'),
    ('move 1 from 3 to 6'),
    ('move 1 from 8 to 2'),
    ('move 18 from 6 to 2'),
    ('move 1 from 6 to 2'),
    ('move 2 from 8 to 3'),
    ('move 3 from 3 to 8'),
    ('move 18 from 4 to 9'),
    ('move 11 from 9 to 2'),
    ('move 2 from 9 to 6'),
    ('move 2 from 4 to 1'),
    ('move 1 from 1 to 5'),
    ('move 1 from 5 to 4'),
    ('move 1 from 4 to 8'),
    ('move 42 from 2 to 1'),
    ('move 3 from 9 to 3'),
    ('move 1 from 8 to 1'),
    ('move 1 from 3 to 4'),
    ('move 3 from 8 to 7'),
    ('move 1 from 4 to 1'),
    ('move 2 from 3 to 2'),
    ('move 17 from 1 to 6'),
    ('move 15 from 6 to 3'),
    ('move 2 from 9 to 7'),
    ('move 1 from 3 to 6'),
    ('move 2 from 7 to 6'),
    ('move 2 from 2 to 4'),
    ('move 1 from 2 to 3'),
    ('move 1 from 4 to 9'),
    ('move 1 from 4 to 1'),
    ('move 1 from 6 to 3'),
    ('move 20 from 1 to 9'),
    ('move 6 from 1 to 9'),
    ('move 7 from 9 to 3'),
    ('move 20 from 9 to 1'),
    ('move 1 from 6 to 7'),
    ('move 2 from 6 to 7'),
    ('move 1 from 6 to 5'),
    ('move 1 from 6 to 8'),
    ('move 4 from 7 to 3'),
    ('move 3 from 7 to 2'),
    ('move 1 from 6 to 4'),
    ('move 1 from 2 to 1'),
    ('move 1 from 4 to 9'),
    ('move 21 from 3 to 2'),
    ('move 5 from 3 to 8'),
    ('move 1 from 5 to 1'),
    ('move 2 from 8 to 7'),
    ('move 4 from 8 to 3'),
    ('move 4 from 2 to 5'),
    ('move 19 from 2 to 3'),
    ('move 1 from 9 to 2'),
    ('move 23 from 3 to 2'),
    ('move 2 from 7 to 4'),
    ('move 3 from 5 to 9'),
    ('move 16 from 2 to 1'),
    ('move 1 from 5 to 4'),
    ('move 1 from 9 to 3'),
    ('move 2 from 3 to 8'),
    ('move 3 from 4 to 6'),
    ('move 1 from 6 to 2'),
    ('move 1 from 8 to 6'),
    ('move 5 from 2 to 6'),
    ('move 7 from 6 to 5'),
    ('move 4 from 2 to 6'),
    ('move 6 from 5 to 9'),
    ('move 1 from 8 to 4'),
    ('move 18 from 1 to 9'),
    ('move 1 from 5 to 2'),
    ('move 9 from 9 to 4'),
    ('move 5 from 6 to 3'),
    ('move 9 from 4 to 1'),
    ('move 4 from 9 to 2'),
    ('move 1 from 4 to 8'),
    ('move 1 from 8 to 3'),
    ('move 7 from 1 to 8'),
    ('move 6 from 3 to 2'),
    ('move 10 from 2 to 9'),
    ('move 21 from 1 to 8'),
    ('move 1 from 2 to 8'),
    ('move 19 from 8 to 4'),
    ('move 1 from 8 to 3'),
    ('move 16 from 4 to 8'),
    ('move 1 from 4 to 2'),
    ('move 2 from 1 to 5'),
    ('move 1 from 2 to 3'),
    ('move 1 from 4 to 5'),
    ('move 1 from 4 to 8'),
    ('move 2 from 1 to 3'),
    ('move 3 from 3 to 2'),
    ('move 5 from 9 to 1'),
    ('move 1 from 3 to 4'),
    ('move 4 from 9 to 4'),
    ('move 2 from 1 to 9'),
    ('move 2 from 2 to 5'),
    ('move 1 from 2 to 7'),
    ('move 3 from 1 to 7'),
    ('move 10 from 8 to 6'),
    ('move 4 from 8 to 5'),
    ('move 3 from 4 to 3'),
    ('move 3 from 3 to 4'),
    ('move 1 from 9 to 8'),
    ('move 2 from 7 to 2'),
    ('move 1 from 2 to 1'),
    ('move 4 from 9 to 3');
511 rows affected

CREATE PROCEDURE dbo.PerformRearrangement
    @CratesToMove integer,
    @FromCrateID integer,
    @ToCrateID integer,
    @CranePreservesOrder bit
AS
SET XACT_ABORT, NOCOUNT ON;
SET STATISTICS XML OFF;
SET ROWCOUNT 0;

BEGIN TRANSACTION;

    DECLARE @Moved varchar(8000);

    UPDATE dbo.Stack
    SET @Moved = RIGHT(Crates, @CratesToMove),
        Crates = LEFT(Crates, LEN(Crates) - @CratesToMove)
    WHERE StackID = @FromCrateID;

    IF @CranePreservesOrder = 0
    BEGIN
        SET @Moved = REVERSE(@Moved);
    END;

    UPDATE dbo.Stack
    SET Crates = CONCAT(Crates, @Moved)
    WHERE StackID = @ToCrateID;

COMMIT TRANSACTION;
DECLARE @SQL varchar(max) =
(
    SELECT 
        STRING_AGG
        (
            CONVERT(varchar(max),
                CONCAT
                (
                    'EXECUTE dbo.PerformRearrangement ',
                    '@CratesToMove = ',
                    SUBSTRING(R.Operation, 6, CHARINDEX(' from ', R.Operation) - 6),
                    ', ',
                    '@FromCrateID = ',
                    SUBSTRING(R.Operation, CHARINDEX(' from ', R.Operation) + 6, 1),
                    ', ',
                    '@ToCrateID = ',
                    SUBSTRING(R.Operation, CHARINDEX(' to ', R.Operation) + 4, 1),
                    ', ',
                    '@CranePreservesOrder = 1;'
                )
            ),
            CHAR(13)
        )
        WITHIN GROUP (ORDER BY R.StepID ASC)
    FROM dbo.Rearrangement AS R
);

EXECUTE (@SQL);

SELECT 
    S.StackID, 
    S.Crates 
FROM dbo.Stack AS S
ORDER BY 
    S.StackID;

SELECT 
    TopCrates = STRING_AGG(RIGHT(S.Crates, 1), '')
        WITHIN GROUP (ORDER BY S.StackID ASC)
FROM dbo.Stack AS S;


StackID
Crates


1
Q

2
L

3
MHRF

4
STMJQ

5
DSQNVTHWD

6
DJNRHBBFTB

7
NB

8
JPQQNSWRVVTDH

9
RVGDBZHNNBM




TopCrates


QLFQDBBHM
StackID	Crates
1	Q
2	L
3	MHRF
4	STMJQ
5	DSQNVTHWD
6	DJNRHBBFTB
7	NB
8	JPQQNSWRVVTDH
9	RVGDBZHNNBM