Join multiple stored procedure results using query editor ???

[Aad via AccessMonster.com]

Hi,

I have a stored-procedure which executes seperate (parametrised) sprocs.
The resultset of each seperate sproc is put into a temp.table.
Then all the tables are joined togheter into one resultset.
This is working fine.

Question: is there a way to join the the temp.tables (result sets) in a more
graphically way (query designer)
I would use the result-sets of the executed sprocs in the query designer to
join them correctly.

Thanks,

Aad

 

[Sylvain Lafontaine]

Directly in the query designer? No.

However, if you want to join separate SP into a single resultset without
using a temporary table, one possibility would be to use the OpenRowSource,
OpenRowSet or OpenQuery commands; see:

http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx
http://www.databasejournal.com/features/mssql/article.php/3331881

In your case, probably that converting these SP to table valued functions
should be an even better solution; however, don't forget that using a
temporary table might also be one of the best solution in term of
performance.