random number for a column inside WITH loop for all records
Posted on 2011-03-02
can you just have a random number for a column for all records within a WITH loop?
<columns> values assigned
<Column5, for example should have the same random number for all the records updated within the WITH loop>
<In the next time the loop is run, all the Column5 column values should have the a random number, but all same just for that loop
for example, in the first loop with the first flat file, there may be 3 records for example.For all 3 records, the 5th column should have the same random number.
In the second loop, there may be 7 rows for example, but all of the 5th column should have the same random number together again.
how can this be done?