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)
 2 steps forward, 1 back (progress at least)

Author  Topic 

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2001-09-13 : 12:52:20
Well

I wrote a proc to return a sum of counts using the output parameter.

That proc is being called from another proc.

I wish to call the "sum of counts" proc twice in the procedure, which returns output to an asp page.

In QA, I run the Main proc, and it shows the two EXEC's returning there counts, I just want the values to be in local vars, not "printed" so that the asp page will see the final select, versus the "sum" proc results.

Darn confusing, Hope someone understands.

_________________________
I am 8 Beers short of a case.
Proof:
Phone Rings:
"This is your proctologist calling, we found your head."
   

- Advertisement -