I need help to create a procedure that will allow me to open a table,loop through the table and for each record obtain a value in a certain field and then INSERT it into another table. the second table is empty and i am want to populate it with a value coming from all the records of the first table.