I've looked high and low for the answer to this question. What I've found is close. But, unfortunately not close enough.

I've experimented with ideas and keep getting errors. Now after that boring introduction, here's the question.

Is there a way to use the result of a stored procedure as the parameter to another stored procedure. Here's what I'm thinking.

... skipping the sp preamble to conserve space ...

set @test2 = usp_another_sp @test1

The concept here is that the current stored procedure would modify the data that is passed into it as a parameter, after that parameter is passed to another stored procedure.

If I haven't lost you, does anyone have any ideas?