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:11:03
|
| 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 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-11-03 : 11:40:13
|
| this is a very general question, there could be so many factors. test it out and see. pull the data in a dev test environment and try it out. depends on your setup, table structure , the code you write, machine type etc ..i think<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
script to run thru a table, updating onother