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 |
|
hollyquinn
Starting Member
31 Posts |
 Posted - 2009-05-27 : 17:08:54
|
| I have the following issue. I have a user here that created an Access Database with one table and then filled it with over 2 million records. They then created a second table called Secondary, and renamed the first table as Primary. They split the primary table down the middle, took all of the columns and data and put it in the secondary table. They used the ID from the primary table as a foreign key. I have just imported this database into SQL Server. I'm very new to SQL Server and unsure how to merge these two tables, or if I should even merge them?? Can anyone give me any advice on how to do this? If you need any further info, please let me know. Thanks. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2009-05-27 : 23:44:06
|
| Your decision needs to be based on normalized table design (search for that for lots of info on this site or others) not on what you have now. If you want to post the table structure here people can help with the design. |
 |
|
|
|
|
|
Should I merge two tables and how?