procedure into a select query 1

[Cagliostro]

Hi,
Is it possible to put stored procedure into a select query? and if yes, how? John Fill

ivfmd@mail.md

 

[fluteplr]

no, if you are using sql 2000 you could recode your procedure as a function which can be selected from.

 

[Cagliostro]

It is very good, but I how about MSSQL7? John Fill

ivfmd@mail.md

 

[tlbroadbent]

In MSSQL7 you have no way to directly Select from a stored procedure. However, you can Insert the output of a stored procedure into a table (temporary or otherwise) and then select from the table.

Example:

Insert #tmptbl Exec MyProc

Select * From #tmptbl