Update multiple rows in sql server 9.0.5000 : I'mk currently creating a script automatically with a program that copies files from one place to another, and I used to do the following:

    UPDATE d
    SET Path= t.Path
    FROM dbo.tableOperation d
    JOIN (
        VALUES
            (1,'Path 1'),
            (2,'Path 2')
        ) t (IdRegister, Path) ON t.IdRegister = d.IdRegister

And on the version of SQL server (10.50.1600) it was working fine, but I found some issues when trying to execute the script on the server I have to update the data (9.0.50000).

I have to update tenths of thousands rows at a time, how can I do it?