Get columns from resultset of stored procedure

Question

Is their any way to get the specific columns from the result set of stored procedure

eg SELECT COL1,COL2 FROM EXEC SP_NAME

possible duplicate of [How to SELECT * INTO \[temp table\] FROM \[stored procedure\]](http://stackoverflow.com/q/653714/11683) — GSerg, Dec 10 '13 at 12:19
already saw these links, none of them help to solve my problem — user3085995, Dec 10 '13 at 12:26
`select col1, col2 from openrowset(...)` solves your problem. It is mentioned in the links. — GSerg, Dec 10 '13 at 12:36

score 0 · Answer 1 · answered Dec 10 '13 at 12:37

0

Something like this (using the self-linked server trick):

Select * 
from openquery(
   MyLocalServer, 'exec mydbo.dbo.myStoredProc @Param=1'
)

answered Dec 10 '13 at 12:37

jean

what is `MyLocalServer` a string? – user3085995 Dec 10 '13 at 12:44
To use openquery command you ill need a linked server that string is a link from local server to itself. http://technet.microsoft.com/pt-br/library/ms188427.aspx – jean Dec 10 '13 at 12:56
Add a linked server. http://technet.microsoft.com/pt-br/library/ms190479.aspx – jean Dec 10 '13 at 12:59

Pankaj Jawale · Answer 2 · 2013-12-11T05:08:34.140

0

You can do some thing like this

create table #temp (temp_table_Schema_as_output_from_Stored_procedue)
insert into #temp
exec SP_NAME @parameters 

select COL1,COL2 from #temp

edited Dec 11 '13 at 05:08

answered Dec 10 '13 at 12:39

Pankaj Jawale

2 Answers2