Thank you <b>VERY</b> much Klaas-Jan - that seems to have worked.

Now I can use that technique for my really big query.

Enjoy your day - Regards John Groom

Unfortunately it doesn't.

The temp_all_masters tables contains a list of master part codes. eg ABCDEF

The temp_non_masters tables contains a list of part codes which are made up of master-part-code + minor-part-code. eg ABCDEFabcde

(not...

Problem solved - found a reference to SET NOCOUNT ON in another post although it did not match my query.

Itried it and the SP now workd from ASP as well.

...