Search code examples
sqljoinexcepttemp-tables

Sql temp table with except

I am trying to insert the records that come of this query into a temp table. Any help or suggestion will be helpful

insert into #AddRec
select *
from stg di
right join
ED bp
on
bp.ID = di.ID
except
select *
from stg di
inner join
ED bp
on
bp.ID = di.ID
Solution

  • This may help it simplifies your query a little.

    create table #AddRec(id int) ;

insert into #addrec
select  ed.id
from stg right join 
ed on stg.id=ed.id 
where stg.id is null;

select * from #Addrec

    If you need more fields from the tables add the definitions into the temp table and add them into the select line