
October 27th, 2004, 11:50 AM
|
 |
Moron
|
|
Join Date: Jul 2003
Location: Michigan, USA
Posts: 170

Time spent in forums: 10 h 31 m 37 sec
Reputation Power: 6
|
|
|
Replication question
I'm trying to figure out an easy way to merge data from one table on a database to another table.
What's happening is two different applications, normal user and accounting, competing for access to a single table. What I want to do is have the normal user application write to a different table and at the end of the night update the original table with any data that has been entered throughout the day.
I know I can schedule a task with SQL Server Agent to run a query with something like:
insert into tableA (select * from tableB)
delete from tableB
I'm just wondering if there is an easier or more robust way of doing this?
|