Cursors are extremely inefficient and should be avoided at all costs. Do not under any circumstances use them to insert or update or delete data. These functions can be done in a set based fashion which is much better for the operation of your overall system. Why? Suppose you have a cursor that returns 100,000 records. A set based update statement will perform the update to all the records which need it in one pass, a cursor will run 100,000 updates. This is the differnce between minutes and hours and millsecond or minutes in terms of processing records. Cursors are bad news. They shoulod only be used when you are doing something that cannot be done in a set based fashion (sending emails to the user is one case, running syustem procedures against all the tables in the database would be another).
If you are manipulating data, describe to us what you want to do and we will help you create a set-based solution.
Questions about posting. See faq183-874