Working With Two Different Stored Procedures from Different Databases

• Aswanth

  SSChasing Mays

  Points: 608

  More actions

  February 25, 2008 at 12:51 am

  #183279

  Hi..,

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

  Database1 - Employee

  Stored Procedure - Employee_Details

  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

• Denis Leskošek

  SSC Eights!

  Points: 806

  More actions

  February 25, 2008 at 1:19 am

  #781486

  You should use table-valued Functions instead of procedures.

  You can do a simple select on them, use joins and union, ....

  Regerds,

  Denis

• Denis Leskošek

  SSC Eights!

  Points: 806

  More actions

  February 25, 2008 at 1:25 am

  #781487

  Correction if you dont' want to change the objects to functions:

  you can always insert resultset of a procedure to table using:

  INSERT INTO table (field1, field2, ....)

  EXEC procedure @param1, @param2, ......

  Create a temp table first and then run the above statment

  Regards,

  Denis