Join the output of two or more stored procedure
-
I have three stored procs and one main caller proc which will call those three procs.
How can we join the output of two or more stored proc?
-
Can someone please reply?
-
capture their data in temp-tables (#tmpprocx, #tmpprocy, #tmpprocz) and join these 3 tables.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
As ALZDBA stated insert the procedure results to a temp table.
CREATE TABLE #TEMP (....)
INSERT INTO #TEMP
EXEC ProcedureName
Then join on the tables.
-
or if you can use openrowset
select a.*
from openrowset('SQLOLEDB',...., 'exec proc1') a
inner join
openrowset('SQLOLEDB',...., 'exec proc2') b
where ...
* Noel -
Thanks for ur reply........
This is what the answer i m looking for.
-
indeed, the openrowset may be the "more dynamic" and "let's see what we get" way, but how will it behave regarding performance.
btw in house we are not alowed to use openrowset except for DRP processes
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply