Re: Generating a random value...

[Bob Field]

You can do it with a single SQL statement:

INSERT INTO newtable
SELECT itemName1, rand()*(value1_max-value1_min)+value1_min
FROM oldtable;

Edited 1 time(s). Last edit at 07/25/2006 01:36PM by Bob Field.