Transfer data from one table to another
Posted on 2007-12-04
Ill try to explain as best as I can: I am Using MS SQL 2005
Database has two tables: Cases and Caselinks
Right now I have 1000 cases, 1000 rows under the case table, I need to transfer the id's from that table to the 'Caselinks' table, here is how its needed:
"Cases" table has the following items:
+I need to transfer the 'firmid' of the cases table to the 'firmid' of the 'caselinks' table.
+From the cases table I need to transfer the 'id' to the 'caseidlinked' ONLY if the 'maincase' = 0 and the 'caseidmain' will be that 'id' of a row where the 'caseid' is the same but the 'maincase' = 1
Please let me know if more information is needed. In short right now the 'cases' are linked by the 'caseid' and now we are moving the info to a new table to link them by the 'id'.
This may be complex but I hope its possible.