Working With Two Different Stored Procedures from Different Databases

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Denis Leskošek SSC Eights! Points: 806 More actions · Answer 1

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 · Answer 2

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