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)
 Using SPROC in another SPROC

Author  Topic 

sillybus
Starting Member

13 Posts

Posted - 2001-05-09 : 10:02:27
I have a sproc that returns several columns of data that I sort of wish to use within another sproc because of how complicated the first sproc is. My problem is that I don't want to create a temporary table to hold the return values since I only need to perform a MIN function on one of the columns. Does anyone know of a way to do something along the lines of this:

SELECT MIN([Category Score]) FROM (EXECUTE usp_panelReview(NULL,1,'a',NULL))

Any guidance is appreciated.

   

- Advertisement -