What I am looking to do is use a complicated stored procedure to get
data for me while in another stored procedure.

Its like a view, but a view you can't pass parameters to.

In essence I would like a sproc that would be like this

Create Procedure NewSproc
AS

Select * from MAIN_SPROC 'a','b',.....
WHERE .........


Or Delcare Table @TEMP
@Temp = MAIN_SPROC 'a','b',.....

Any ideas how I could return rows of data from a sproc into another
sproc and then run a WHERE clause on that data?

Thanks
Chris Auer