Looping

[Vincent Oh]

Hi, I'm new do stored procedures so I will need some help with this.

Let's say i got a table (Employee) with 4 important fields (id, firstname, lastname, age, etc,...., etc, etc).

Now i need to retrieve these 4 fields and for each row, i will need to execute an update statement so that i can update another table (Salary) based on the 4 values from Employee.

How do i write the procedure to have such a loop that i can first do a SELECT statement from Employee, then loop through the results to do the UPDATE?

Thanks alot.