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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  inserting and updating records

Author  Topic  abyie Starting Member 42 Posts Posted - 2006-08-24 : 11:54:49 Hi, I am trying to first bulkinsert all the data from a few fields from multiple tables in Database A to a table( this table has all the fields) on another database B on the same server.Thereafter would do updates on Database B .Could you plz lemee know what are the best possible ways of doing that. I have already created a procedure that would do that for me.But I am looking for best possible ways of doing it. Your help would greatly be appreciated. Thanks -------- Abyie