Subject | calling an SP a variable number of times |
---|---|
Author | Roger Pullen |
Post date | 2004-04-05T19:38:05Z |
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(!)
Regards
Roger Pullen
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(!)
Regards
Roger Pullen