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.
| Author |
Topic |
|
DBASlut
Yak Posting Veteran
71 Posts |
 Posted - 2005-09-09 : 18:22:11
|
| here's the scenario..cursor 1 using select from table1while @@fetch = 0 begin update table1fetch nextwhen this is run, it appears the same record from the cursor is being called.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-09 : 18:22:59
|
| What is your question? Post the actual code in order for us to help.Tara |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-10 : 00:48:05
|
| Instead of using Cursor, Use normal Update query which is more efficient than using CursorPost table structure and your exact needMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
cursor madness