Re: multiple output from store procedure

[Jay Alverson]

Well, I don't see what the problem is...

That's what computers are for, to do complex, repetitive work and keep track of it all.

If you need the "single row" over and over, then see if you can either place it
into a TEMPORARY table or, into a CURSOR, for repeated use.

As for the "lot of variables" they probably don't take up too much space, from the size(s) you declared.

How long does the SP take to run ? Is that the issue ? Time ?
Does it cause your other users to suffer while it's running ?

>

Thanks, Jay