How can I use the value of a column (the value of which is generated by the decimal/numeric generator) to generate the value of another column? For example, I have a table with Height and Weight columns. I am generating values for the Height column using the decimal/numeric generator. Then I want to use the Height value to produce a corresponding Weight value. I thought I should be able to use the SQL Statement generator to do this, but either it doesn't work, or I am not using it correctly. For instance, I would like to do something like this:
SELECT 25 * Height * Height FROM <tablename>
and store the result in the Weight column, and have it work for each row that gets generated.
Unfortunately, the values I get back don't make sense.