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 |
|
dadunn
Yak Posting Veteran
67 Posts |
 Posted - 2001-04-04 : 16:47:43
|
| I have been asked to switch the data in two fields of a table to get around an issue with our vendor app.This table has several hundred thousand rows. I know I might be able to do this with a cursor, but I thought there was a more efficient way to make SQL deal with a recordset one row at a time.I was thinking I could cheat by pulling the two fields into a temporary table and then doing an update to the original table.Any thoughts?Dave |
|
|
|
|
|
Alternative to Cursor