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 |
|
Johnyalm
Starting Member
49 Posts |
 Posted - 2009-10-31 : 03:27:22
|
| I would like to run thru a table (table ONE) with at least 10 000 rows, and then update another table by executing a stored procedure.Is there a time out problem if there are a lot of rows, and the executed stored procedure has to update at least 10 rows in another table, that makes 100 000 rows in table TWO.Im a newbie so if there is as well a suggestion about how the script shall be written the I would be very glad.www.mirrorgate.com |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-10-31 : 18:54:52
|
| Without seeing your code we have no idea how long your code might take to execute. But in general, 100,000 rows isn't particularly big, so with proper code and indexing your script should run without timing out.JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
loop and update another table