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 |
|
rcurrey
Starting Member
30 Posts |
 Posted - 2007-02-23 : 09:43:49
|
| Sorry. Posted this in the wrong forum originally.create table promo (id float not null,fname varchar(30),lname varchar(30),address varchar(50),item float,qty int)This table is inserted with id, item, and qty filled out. The personal information that goes with the id resides in another db on a separate server. We need to update this table using the external table's information. The PROMO table will have several hundred rows per day being inserted. The table with the personal info has over 11,000,000 rows. We only use openrowset (no linked servers allowed).Looking for suggestions on how to best accomplish this. Any help would be appreciated.Thanks,Rich |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-23 : 21:21:56
|
| Simplest is probably to retrieve maybe 50 rows at a time into a staging table and do the update from there. That would mean maybe 20 calls per day which sholdn't take long.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
updating from a very large table