I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server ... a pre-existing random field) records to value 1, then the next 428 to 2, the next ...

You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views. Any column that is not modified retains its original values ... use the ...

It’s sometimes difficult to know which SQL syntax to use when combining data that spans ... of querying multiple tables is effectively an implied JOIN. Your database may handle things ...