Richard Huxton wrote:
Mike Adams wrote:
So.
The first query should pull all 'MOM' records that have one or more
corresponding, and possibly orphaned, unassigned receiving records
belonging to the same po_cd and item_cd.
The second query should pull all unassigned, and possibl
Richard Huxton wrote:
(quoted OP lines edited for brevity...)
Mike Adams wrote:
...
I've reworked two
queries (as text attachment as they are wide lines) to enhance the
planner's chance of speeding up the queries (Oracle8i's).
Well, I can't say it's standard pr
Hello! I'm a long time lurker who has become responsible for maintaining
/ updating utility queries at work. I've reworked two queries (as text
attachment as they are wide lines) to enhance the planner's chance of
speeding up the queries (Oracle8i's).
I'm looking for someone to eyeball them a
