I have an old table in sql server 2005. I like to migrate data from old table to the newly created table.
This is only a table look up. I have already populated the newly created table with known records but the old table has 5 years of historical data and I need to compare if something from old table does not exists in the new table then I create it as a new record, how that can be done? The comparison needs to be done on ColXX only.
Col1, cols2, ColXX Col1, Col2, ColXX
Thanks in advance