I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server 2000, sp3). I've got it working perfectly except I can't use a variable inside my subquery ...

6) issue an update statement with same type of update, but restricted to the row belonging to that PK value. 7) detect if it fails and log if needed 8) continue to iterate until no more record found ...