rut_new (3/9/2013)
Really going crazy here!I have table1 and table2 [for e.g. purpse]. They are of exact design:
id [autoincrement, primary key, int]
name [varchar(10))
creatorid [int] --code of the office which inserted the row?
both can contain the same id value. I need to bring table1 data to table2 while keeping the data. The db was designed for use in a NT but now there are offices which are not networked and their data needs to come to the central office thru export. How do we do that?
Every row got id of the office which created it. The problem is that the id column is referenced in other tables. Any insight please?
Can you give us some DDL and sample data depicting your problem?
It will then be easier for us to give you a tested solution.
If you are not sure on how to do this, please check the link in my signature.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/