copy records from one identical table to another identical table on two different datbases
I have database1 with tblAttendance. I also have database2 with tblAttendance. There is a column in the table called Redetermination which determines which records will be migrated to the new database and table.
I would like to transfer all records from dbo.database1.tblAttendance where tblAttendance.Redetermination = 1 to dbo.database2.tblAttendance
How can I do that using SQL statments. Unless there is also a wizard that does this function...