Stored procedure result to variable

[Rauland]

How would I assign the value of the result of executing a stored procedure to a variable.

I tried this:

exec @var = proc1

But this assigns the return value and not the result , to @var.

I believe the return value will return 0 if no errors occur.
Thanks