Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 replace cursor

Author  Topic 

elenabul
Starting Member

7 Posts

Posted - 2004-10-15 : 06:14:59
I use stored procedure with cursor on a table with 100000 records.
The cursor is very slow. If you know any way to replace the cursor I will appreciate your help.

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-10-15 : 07:42:14
Cursors often can be replaced with Set Processing, but you need to provide some more information about your specific situation.
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-10-15 : 08:46:36
Should we start handing out yearly "Yakky" awards like "Most ESP Required" or "Least Amount of Information Provided" for questions?

By the way -- this is the Access forum. I doubt you are using stored procedures in Access.

- Jeff
Go to Top of Page
   

- Advertisement -