• You welcome.

    This UPDATE has 2 other imprescriptible parts outside of the sattement itself:

    [Code]ORDER BY StaffName, ReviewDate[/Code]

    which inserts rows in the table in specific order and

    [Code]ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,[/Code]

    which holds the rows in the order they've been inserted.

    If you want to perform the same trick on a static table you need to have specifically crafted index and use WITH INDEX hint.

    _____________
    Code for TallyGenerator