I have a SQL Stored Procedure that generates data for one GP Company. Is there a way to pass a database through as a parameter to return a combined report? For example, how would I go about getting a combined AP Aging for three GP companies?
Any samples would be greatly appreciated.
Thanks!
Ryan
*This post is locked for comments
Ryan, please see the link in my post above which discusses about how to capture the results returned from a stored procedure. The idea is to capture the result set for each company into a temp table and then combine these temp tables via a SQL UNION.
I am cutting and pasting the sample script to save the results of a stored proc to a table:
INSERT INTO SomeTableThatMatchesTheSproc (...)
EXEC StoredProcedureName
SELECT * FROM SomeTableThatMatchesTheSproc
Thanks Victoria. I have followed your blogs before. This gets me what I need.
If I am to get a historical aging, is there a way to execute a stored proc on each db and have results returned?
Ryan,
If you know the names of the databases and companies upfront and are ok with hardcoding them, this is pretty straightforward. Here is an example of a multicompany view:
You can try to select from a stored procedure into a temp table for each of the companies. After that, assuming you have created the temp tables COMPANY1..temp, COMPANY2..temp, you can do a UNION ALL:
SELECT * FROM COMPANY1..temp
UNION ALL
SELECT * FROM COMPANY2..temp
....
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
