SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.table1(c1 int, c2 int, c3 varchar(32), PRIMARY KEY(c1,c2));
INSERT dbo.table1 VALUES(1,2,'hi'),(2,3,'bye');

CREATE TABLE dbo.table2(c1 int, c2 int, c3 varchar(32), PRIMARY KEY(c1,c2));
INSERT dbo.table2 VALUES(1,2,'hi'),(3,4,'what');
4 rows affected

SELECT * FROM dbo.table1;

SELECT * FROM dbo.table2;

SELECT 'Need to add', * FROM dbo.table1 AS t1
WHERE NOT EXISTS
(SELECT 1 FROM dbo.table2 AS t2 WHERE t2.c1 = t1.c1 AND t2.c2 = t1.c2);


c1
c2
c3


1
2
hi

2
3
bye




c1
c2
c3


1
2
hi

3
4
what




(No column name)
c1
c2
c3


Need to add
2
3
bye


CREATE PROCEDURE dbo.MoveTable1RowsToTable2
AS
BEGIN
  SET NOCOUNT ON;
  
  INSERT dbo.table2(c1, c2, c3)
    SELECT c1, c2, c3
    FROM dbo.table1 AS t1
      WHERE NOT EXISTS
      (
        SELECT 1 FROM dbo.table2 AS t2
        WHERE t2.c1 = t1.c1 AND t2.c2 = t1.c2
      );
END
EXEC dbo.MoveTable1RowsToTable2;
SELECT * FROM dbo.table1;

SELECT * FROM dbo.table2;


c1
c2
c3


1
2
hi

2
3
bye




c1
c2
c3


1
2
hi

2
3
bye

3
4
what