1. Insert the value in a table variable first.
2. Check the existence.
3. Insert or show message.
DECLARE @TmpTbl TABLE (Col1 VARCHAR(100), col2 VARCHAR(100))
INSERT INTO @TmpTbl(Col1,Col2)VALUES('EDJ','LP'), ('AGE', 'LP'), ('DJR', 'VG')
IF NOT EXISTS(
SELECT 1
FROM Table1 t1
INNER JOIN @TmpTbl t2
ON t.Col1 = t2.Col1
AND t1.Col2 = t2.Col2
)
BEGIN
INSERT INTO Table1(Col1,Col2)
SELECT Col1,Col2
FROM @TmpTbl tt
END
ELSE
BEGIN
PRINT 'Data already exist.'
END