Best way to combine stored procedure and query

Question

I am making a report in SSRS and some of the data is being obtained from a query, while other data such as db size is being taken from stored procedure (sp_databases)...

How can I join this data?

I was wondering what would be the best way to join these? Temp table? To my knowledge I cannot use a view since they cant call stored procedures, am I correct?

Using a SQL Script may be ... another main procedure. – Rahul Jun 09 '14 at 14:42 — Rahul, Jun 09 '14 at 14:42

score -1 · Accepted Answer · edited May 23 '17 at 11:49

-1

Pull the data you want from the stored procedure into a temp table and use that temp table along with your query in a stored proc you can call from the SSRS report.

This question might help with the first part. Question

edited May 23 '17 at 11:49

Community

1
1

answered Jun 09 '14 at 14:53

Daniel E.

2,029
3
22
28

score -1 · Answer 2 · answered Jun 09 '14 at 14:54

-1

You can call the results of the SP like this:

SELECT tmp.*
FROM OPENROWSET('SQLOLEDB', 'my_sqlserver_name';'my_sqluser_login';'my_sqlpass word',
'EXEC mydatabase.dbo.mystoredprodedure') AS tmp

And then join or union to your other query.

answered Jun 09 '14 at 14:54

Sev09

883
2
12
27

Best way to combine stored procedure and query

2 Answers2