Working With Two Different Stored Procedures from Different Databases in Sql Server

[Aswanth]

Hi..,
I'm having Two Stored Procedures in Two Different Databases..

Database1 - Employee
Stored Procedure - Employee_Detail s

Database2 - Company
Stored Procedure - Company_Details


In Each Stored Procedure I Joined Three Tables(Inner Join) in both the Databases..

Now I want to Join these Two Stored Procedures from Different Databases to get My Result..

How to do this..


Thank You

[radcaesar]

Output the 2 sp results into a temp table via a Cursor and then make the recordset available from the #temp table

Then Delete that #temp table.

[debasisdas]

You can't join stored procedures.

Please follow as suggested in previous post.

[ck9663]

Try to use table function for your stored proc. That way both will return resultset that you can join.

-- CK