Hi all,
I have a query I am running where I want to check the value of 2 or more values returned by stored procedures. Something like:
exec @var1 = dbo.storedProc1 @param
exec @var2 = dbo.storedProc2 @param
exec @var3 = dbo.storedProc3 @param
(The sprocs return bit values)
Then I want to examine the values of @var1, @var2, @var3. But the problem is that after the first stored proc runs, @var1 loses it's value... same for the others...
What am I not understanding?
Any help would be appreciated.
Cheers