the records INSERTed then need to be available to be updated by subsequent records in the driver table - I guess I can say that they are receipt records which...

Grant - that's an interesting solution, which I might just pursue - thanks

Gail - I am under contract at a client hyper sensitive to intellectual material being stolen - when...

I'd check the trigger - could there be an error in the SQL in the UPDATE trigger itself? Is it an AFTER trigger or an INSTEAD OF? Does...

Jeff - on behalf of my client 😛

see http://www.sqlservercentral.com/Forums/Topic1550386-392-1.aspx

I took a stored procedure, modified (but not enough) which had used cursors in Oracle that ran for 88 minutes...

here's the new proc - it ran the night before in 88 minutes

last night it took 4 minutes:w00t:

legal told me to take it down:(

nope, I've nearly got it - thanks again for all your help

I'll post it when done, removing the PRINTs, sundry SELECTs of table variables, etc

no, this stored procedure is running as part of a larger job run as part of a batch at night

I want to thank you guys (you are guys, right?) for all your help. I've got the running total working, now gotta get the rest of it working. ...

after the run

ORDER_ITEMS_STAGE

VALUES ('PARTNO001','000050','04/01/2014','',2,'ATS')

ORDER_ITEMS_STAGE

VALUES ('PARTNO001','000050','05/01/2014','RBAR',2,'ATS')

ORDER_ITEMS_STAGE

VALUES ('PARTNO001','000050','05/01/2014','DTOA',2,'ATS')

ORDER_ITEMS_STAGE

VALUES ('PARTNO001','000050','05/01/2014','DTOA',2,'') - inserted

ORDER_ITEMS_STAGE

VALUES ('PARTNO002','000050','04/01/2014','',4,'ATS')

ORDER_ITEMS_STAGE

VALUES ('PARTNO004','002999','04/01/2014','',4,'ATS')

note no matching Order Item for PART003 - this is OK

right you are

CREATE TABLE AVAILATS

(ITEM_NO VARCHAR(30) NULL,

CUSTNO CHAR(6) NULL,

OPN_QTY INT NULL)

INSERT AVAILATS VALUES('PARTNO001','000050',6)

INSERT AVAILATS VALUES('PARTNO002','000050',4)

INSERT AVAILATS VALUES('PARTNO003','000050',2)

INSERT AVAILATS VALUES('PARTNO004','002999',8)

CREATE TABLE ORDER_ITEMS_STAGE

(ITEM_NO VARCHAR(30) NULL,

CUSTNO CHAR(6) NULL,

REQUIRED_DATE DATE NULL,

DPAS_RTNG CHAR(4) NULL,

REQUIRED_QTY...

the real AVAILATS has 40K records - and the real ORDER_ITEMS_STAGE 3 million records

CREATE TABLE AVAILATS

(ITEM_NO VARCHAR(30) NULL,

CUSTNO CHAR(6) NULL,

OPN_QTY INT NULL)

INSERT AVAILATS VALUES('PARTNO001','000050',6)

INSERT AVAILATS VALUES('PARTNO002','000050',4)

INSERT AVAILATS VALUES('PARTNO003','000050',2)

INSERT...

thank you for making the stored procedure more readable

here's what the procedure does:

it takes a file of Available to Ship

with ItemNo CUSTNO and qty

...

Gail

you rock!

but you knew that already

this also works in SQL Server 2000

I had this problem at an earlier job and it was a dog - arf! Making the WHERE select into a temp file helped a bit. If you...

your question, is, however, in the wrong category

you should post questions like this in the 2005 Newbies thread

that thread seems to be filled with advanced qustions about best practices for...