It turns out that selecting random values from a table column and updating or inserting them into another table is trickier than I imagined. For example, the following SQL snippet seems to work, but it will always assign the first random value to