-
Using SP results within an SP
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?
Thanks,
Mapman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|