moving values from a stored proc into variables

[nathanharcup]

Hi All,
I have a stored procedure that returns 3 columns of data, is there a way I can move each of these columns into variables?

 

[danvlas]

How many rows?

If one, a table variable. Or change the stored proc to return output variables instead of a table.

If more, either a table variable with an IDENTITY column or a cursor.

Maybe someone else here has a better suggestion...


HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[nathanharcup]

Thanks very much, I need to use an input variable in the stored proc.

I tried adding a new variable @var type (100) OUTPUT

Put when run it gives me the message that @var is required.

Can I use both input and output values in the same proc?

 

[nathanharcup]

Think I have sussed it, I was not calling the variable from SP 2 ie.

exec sp_custom @input, @output OUTPUT