At 08:38 PM 5/04/2004 +0100, you wrote:

>Hi all - I have a situation whereby I am trying
>to avoid using temporary tables hence want an SP
>to do the job if at all possible:
>
>I need to call an SP a number of times, each
>with different parameters but return just ONE
>overall result set that itself I do a count
>of unique entries in and only actually return
>the rows whose count equals the number of
>times the SP ran
>
>Hope someone can understand that(!)

IF I understand that (!) then you would need to do all of that in one SP,
with your iterative calls embedded. Exactly HOW depends on where the
parameters are coming from: easiest if they come from a query.

/heLen