Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Simple question regarding exec statement in sp

Author  Topic 

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2001-06-28 : 17:26:28
Hey,

This is a simple question i assume.

I have a stored procedure which takes 3 params, it does some calculations and returns a float.

I return the float by
Select @budget as budgetavailabe

This works well when I call it from ASP

I now have another sp and I want to call the budget sp, but I don't understand How i get the availablebudget var back in the sp,

I was hoping i didn't have to alter my proc to include an OUTPUT param.

I just read the article, but the example is confusing for my situation, I am mentally tired, and its my friday.

a quick slip of help would be appreciated.



Software Composer
   

- Advertisement -