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 ...

Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...

FROM statement using source data that's known to have flaws. Back to the OP - either filter out the bad records in the WHERE clause, or put a CASE statement in the UPDATE list. No need for a cursor.

As in other PROC and DATA steps, you can use only a view descriptor or other SAS data set in an SQL procedure statement, not an access descriptor. You can usually only browse data retrieved using a ...