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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-10 : 09:18:00
|
| Tom writes "Hi,I have to build an application which uses a secondary DB than the actual DB. The secondary database is going to have a table which will be refreshed in every 2 minutes from the actual DB. The information coming to the secondary table is by a INNER JOIN of 3 tables in the actual DB.I want to write a stored procedure for this. In otherwords, which should delete all records in the table (DB2) and insert all the records which meets the WHERE condition, from the first database.Please help.Thanks,Tom" |
|
|
|
|
|
SPs - Inserting and Deleting to a table