TableA has follwoing rows:I assume you meant columns?There are a few different ways you can do this - here are couple of those:INSERT INTO TableA(ServerName, ApplicationID)SELECT b.ServerName, b.ApplicationIDFROM TableB bWHERE NOT EXISTS ( SELECT * FROM TableA a WHERE a.ServerName = b.ServerName AND a.ApplicationId = b.ApplicationId );INSERT INTO TableA(ServerName, ApplicationID)SELECT ServerName, ApplicationIDFROM TableB bEXCEPTSELECT ServerName, ApplicationIDFROM TableA