I am required to populate an integer field using a stored procedure. This field resides in an SQL table that contains thousands of records. Normally I would use an UPDATE statement to perform the task of filling in the value for the whole table. What is the efficient solution to this? I'm thinking of creating a stored procedure to copy the table onto a cursor, access the record, call the stored procedure to update the integer field and then fetch the next record.