[Resolved] Insert problems - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

[Resolved] Insert problems

Author

Topic

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2009-03-09 : 08:14:05

I have an "insert...select" that does not render desired results:

insert into #Combined_JobQtyDetailTable (jobdate, costcode, jdedetailqty, differenceqty) 
select jde_job_date, jde_cost_code, jde_detail_qty, jde_detail_qty * -1
from #JDE_JobQtyDetailTable 
where #Combined_JobQtyDetailTable.eqdetailqty <> jde_detail_qty

Above code does not insert any records. If I comment out the last line ("where ....), all records get inserted. I need to insert only records where "qty" does not already exists. Thank you.

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-03-09 : 08:20:14

insert into #Combined_JobQtyDetailTable (jobdate, costcode, jdedetailqty, differenceqty)
select jde_job_date, jde_cost_code, jde_detail_qty, jde_detail_qty * -1
from #JDE_JobQtyDetailTable
where jde_detail_qty NOT IN (SELECT eqdetailqty FROM #Combined_JobQtyDetailTable)

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-03-09 : 08:20:50

insert into #Combined_JobQtyDetailTable (jobdate, costcode, jdedetailqty, differenceqty)
select jde_job_date, jde_cost_code, jde_detail_qty, jde_detail_qty * -1
from #JDE_JobQtyDetailTable e
where NOT EXISTS (SELECT * FROM #Combined_JobQtyDetailTable WHERE eqdetailqty = e.jde_detail_qty )

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2009-03-09 : 09:10:15

That worked, thank you.

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-03-09 : 09:25:24

quote:
Originally posted by snufse

That worked, thank you.

ur welcome

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources