Rewrite query for SQL Server from Oracle

Question

I have query, help me rewrite it for SQL Server:

insert into swi (co, na, ci, ac, id, version, add) 
    select co, na, ci, acc, id, ?, address 
    from swi_tmp 
    where co||me not in (select co||me from swi)

Now, I have, but it still not working

insert into swi (co, na, ci, ac, id, version, add) 
    select co, na, ci, acc, id, ?, address 
    from swi_tmp 
    where not exists (select 1 
                      from swi_tmp
                      where swi_tmp.co = swi.co and swi_tmp.na = swi.na)

Answer 1

The FROM clause in the NOT EXISTS subquery is using the source table instead of the target table. Change the table name in the NOT EXISTS subquery to the target table name:

INSERT INTO swi (co, na, ci, ac, id, version, add) 
    SELECT co, na, ci, acc, id, ?, address 
    FROM swi_tmp 
    WHERE NOT EXISTS (SELECT 1 
                      FROM swi
                      WHERE
                          swi_tmp.co = swi.co
                          AND swi_tmp.na = swi.na
                     );