Board index » delphi » SQL Server 7.0 Stored Proc and Joins

SQL Server 7.0 Stored Proc and Joins

Hi All,

Does anyone know if you can join a table with a stored procedure that
returns a result set?

Thanks

Joe Lippa

 

Re:SQL Server 7.0 Stored Proc and Joins


No luck. SP would return results to client and therefore would be no longer
a "property" of the server. You could create a temp table in your stored
proc and use it in a different statement for joins with whatever you need.

rb

Quote
"Joe Lippa" <joeli...@contactbox.co.uk> wrote in message

news:3c6d6f11_1@dnews...
Quote
> Does anyone know if you can join a table with a stored procedure that
> returns a result set?

Other Threads