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 2005 Forums  Transact-SQL (2005)  Updating Multiple tables

Author  Topic  Dilan13 Starting Member 6 Posts Posted - 2010-06-08 : 22:09:57 I have a scenario where a table ( Table A) is loaded from a data source, and I have another table ( Table B) which is loaded from Table A, and also has additional columns which get modified from a tool.( the data from table will be viewed from a report) The request is to update table B every time we have new data in Table A( think it as actuals being loaded every month), but we don't want to see old records that don't exist in table A anymore in Table B, and also the columns in table B that get changed by the user from the 3rd party tool should be not lost) My question is what is the best approach to implement it? Currently here's what I am doing, I created another table C(Copy of table B) ANd every time we load new data to Table B, it gets rebuilt completely( truncate the table and add new data), insert any new records in table B into Table C, and then update table B from the data from Table C( only the columns that users modify in the table B, I am also updating table C everytime a user updates table B) let me know if there's a better approach?