If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I have 2 to 3 columns in one table that really should be in another table. Is there a way to move columns and data over to another table. I was thinking something like creating the a new table with all the columns I want and then doing an insert based on a select. This will be eventually changed on a production database so I need to keep the names of the tables the same. Thanks for any suggestions.