getting contents from a table returned by sp

[dky1e]

Is there a way to get the contents of a table returned by a stored procedure?

For example if I have a sp:
create procedure test
as
select 'test'

how can i get at the returned table from the sp from another sp?
I want to do something like: "select * from test"

 

[tlbroadbent]

If you are using SQL Server you can insert the result set from a stored proc into a table or temp table.

Create table #temp(<column definitions to match SP result set>)

Insert #temp
Exec Test

It is best to post quetion like these in the forum for your database rather than this general ANSI SQL forum. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[dky1e]

Thanks! I'll try it first thing tomorrow.

PS
I thought i was posting to sql server forum, i must have clicked on the wrong link...