I've got a SQL Server 2008 R2 database which contains two identical tables, one for "current" records and one for "archived" records (not my choice, but what I have to work with).
I'd like to move records from the current table to the archive table without explicitly identifying the 75+ fields in the two tables.
I'm hoping there is a way to do something like:
INSERT INTO tbl_Archive
SELECT * FROM tbl_Current
INNER JOIN tbl_Archived_IDs on tbl_Current.ID = tbl_ArchivedIDs.Id
And then do a deletion from tbl_Current, for those records which were just copied.
If there is an easy way to do this, please advise.