additional query on resultset????

[Bebe]

I have a stored procedure that returns invoice order numbers that did not seem to get processed.

from those numbers listed in my result set I then want to query out all those invoice order numbers that were cancelled from another table.

could someone give some sample code on how to do this?

so I get a bunch of numbers back from a query and now i want to query on those numbers and make sure none were cancelled???

[GRAHAM]

Hi Bebe

I got around a similar problem by adding another field i.e "Processed" which held a value of Y for yes, N for no,
then did a search for all records with "N".

Perhaps you could implement something along those lines.

GRAHAM