INSERT INTO
    TMP.dbo.BAD_Kupno
SELECT
    ID_Kupna, ID_Lotniska, ID_Samolotu, Ilosc, Kwota, Zrodlo, TIMESTAMP
FROM
    TMP.dbo.TMP_Kupno
INTERSECT SELECT
    TKK.T_Value, ID_Lotniska, ID_Samolotu, Ilosc, Kwota, Zrodlo, TIMESTAMP
FROM
    TARGET.dbo.Kupno K
join
    TARGET.dbo.T_KEY_KUPNO TKK
ON
    K.T_ID = TKK.T_ID
except SELECT
    ID_Kupna, ID_Lotniska, ID_Samolotu, Ilosc, Kwota, Zrodlo, TIMESTAMP
FROM
    TMP.dbo.BAD_Kupno;