<div>
To the best of my knowledge this is not possible. &nbsp;I really wish it was as there are a number of occasions where I'd use it myself.<br />
<br />
I think that the only thing you can do it put the results of the SP into a temporary table and use that in your SELECT query.<br />
<br />
INSERT INTO #myTable exec sp_GetMyResults<br />
<br />
Colin
</div>


To the best of my knowledge this is not possible.  I really wish it was as there are a number of occasions where I'd use it myself.

I think that the only thing you can do it put the results of the SP into a temporary table and use that in your SELECT query.

INSERT INTO #myTable exec sp_GetMyResults

Colin

<div>
amnav: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
EXPERTS:<br />
Post your closing recommendations! &nbsp;No comment means you don't care.
</div>


amnav:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 [http:/help/closing.jsp#1] 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

<div>
<div class="content wysiwyg-content">
How can i use stored procedure in a select statement as a table
</div>
</div>


How can i use stored procedure in a select statement as a table

using SP as a table in a select statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.