Posted by Doug on 03/13/06 00:11

i can't help you with the syntax, but this has GOT to be slow to run if
this table has any size to it.
is this an issue?
if so, consider changing the last line to
WHERE (left(MFG.dbo.PURC_ORDER_LINE.USER_1,3)= 'Aut'))

Consider finding logic to limit the search through PURC_ORDER_LINE. For
instance, is the vendor currently a specific wrong thing? Are they
always blank?
Anything you can do do limit the records in PURC_ORDER_LINE will speed
it all up a bunch.

[Back to original message]