Viewing 2 posts - 1 through 3 (of 3 total)
didn't get a chance to try your code, but here is the code that did the trick for me.
DELETE t
FROM YourTable t
INNER JOIN
(SELECT ord_type ord_no item_no line_seq_no
FROM YourTable
WHERE...
June 25, 2008 at 7:22 am
#833925
Things have changed a bit since that post. I think I've simplified the issue.
I have the following records:
ord_type ord_no Item_no line_seq_no cd_tp
O ...
June 24, 2008 at 1:38 pm
#833568