Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 join SP to table inside Reporting Services

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2004-09-27 : 15:55:57
I have a SP called Patients.
I would like to join this SP to the Organization table inside of Reporting Services.

How can I do this?



tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-27 : 15:59:36
You can't join a stored procedure to a table. You would need to dump the results of the stored procedure into a temp table and join to that.

Tara
Go to Top of Page
   

- Advertisement -