Chaps (and anyone else who may be able to help)...
The outer sp iterates a cursor to find an available record. If it doesnt find one it returns a negtive condition, if it finds one it returns the record's ID...

I have the nested sp working fine in my outer SP, sadly, calling the Outer SP via VB gives me back the first result from the first nested call ?

SET NOCOUNT does not work for this. Is there a SET or something that will suppress the inner call SELECT ??

Cheers

Chubby..