how to transfer one table data to another table in sql server?
['INSERT INTO SELECT requires that data types in source and target tables match.', 'The existing records in the target table are unaffected.']