SQL Server Performance Forum – Threads Archive

use results from a SP in an SP

I have a question for you all… I am trying to execute a stored procedure within another stored procedure and use one column from the result set in the top sp… The nested SP is on a remote server that doesn’t allow DTC, so I cannot create a temp table and then insert the result set in the temp table by… insert into #temp exec sp2 If I just exec sp2 I get the results just fine, but what can I do with them at that point? Thanks,

---

nm…. I figured it out…
Exec SP2 @input, @output output and I got my output… assigned to the @output variable.

---

]]>