I've created a cursor to select all rows from a table and have an ORDER BY clause in the select statement. If I try to update the data in the table, SQL Server gives me an error stating that the cursor is read only. If I select the data without the ORDER BY clause, there is no problem. Is there a way to update the table with the ORDER BY clause in the select statement of the cursor?

Thanks!!!

Why are you using a cursor? Chances are you can do what you want without the cursor.

regards
David Cameron

And in any case, why would you want to update rows in a particular order? What difference does the order make when you do an update?

The reason why the cursor is not updateable is because of the presence of the ORDER BY clause. The clause means that the cursor has created a temporary table to sort the rows. Allowing the update would mean you would update the temporary table - not terribly useful...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com