Sql temp table with except
except, join, sql, temp-tables
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
Problem
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 ```