Home Forums SQL Server 7,2000 T-SQL Copy data from one table to another table RE: Copy data from one table to another table
Sam-638661
Say Hey Kid
Points: 701
More actions
May 20, 2008 at 7:15 am
#817842
This is another way of the same workaround with better performance:
insert into empcheck1
select emp.*
from emp
left join empcheck1
on emp.empid=empcheck1.empid
where empcheck1.empid is null