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

  • 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