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.ApplicationID
FROM
TableB b
WHERE
NOT EXISTS
( SELECT * FROM TableA a WHERE
a.ServerName = b.ServerName
AND a.ApplicationId = b.ApplicationId
);
INSERT INTO TableA
(ServerName, ApplicationID)
SELECT
ServerName, ApplicationID
FROM
TableB b
EXCEPT
SELECT
ServerName, ApplicationID
FROM
TableA
Query help
Posted - 02/05/2013 : 14:43:15
