The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statementhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspxUpdated 20 Mar 2009: This code is revisited here . This nifty little trick will allow you, with some limitations, to treat the output of a stored procedure as a named SQL record set rather than creating a table and going through an INSERT.. EXEC process.en-USCommunityServer 2.1 SP1 (Build: 61025.2)Loading An XML Document Into SQL Server: Another OPENROWSET Trickhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#425357Sun, 16 Apr 2006 09:57:03 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:425357Ward Pond's SQL Server blogA quick-and-dirty solution for importing file-based XML documents into SQL Server tables is discussed.A Shiny New Corner of The Blogospherehttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#444705Thu, 03 Aug 2006 07:50:09 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:444705Ward Pond's SQL Server blogAll I did was ask a question, honest.. <br>When I was vetting my recent post regarding database design issues,...http://sqlservercode.blogspot.com/2006/08/store-output-of-stored-procedure-in.htmlhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#445577Tue, 08 Aug 2006 23:08:42 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:445577TrackBackhttp://sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=291512http://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#453107Thu, 31 Aug 2006 20:33:38 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:453107TrackBackre: The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statementhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3035176Fri, 11 Apr 2008 20:44:57 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3035176RON<p>Thank you so much for sharing this. &nbsp;I've been looking for this solution for a long time. &nbsp;I really appriceiate it.</p>http://eggheadcafe.com/community/aspnet/13/10034706/using-openrowset.aspxhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3051027Tue, 06 May 2008 16:45:29 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3051027TrackBackhttp://eggheadcafe.com/community/aspnet/9/10032061/openrowset-option.aspxhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3115616Tue, 02 Sep 2008 06:05:02 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3115616TrackBackhttp://eggheadcafe.com/community/aspnet/13/10034703/use-openrowset.aspxhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3127503Wed, 24 Sep 2008 02:07:57 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3127503TrackBackhttp://stackoverflow.com/questions/209383/select-columns-from-result-set-of-stored-procedurehttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3151071Tue, 11 Nov 2008 18:38:22 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3151071TrackBackre: The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statementhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3214626Wed, 18 Mar 2009 15:30:32 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3214626Giles Collingwood<p>Nice - does it work with parameters too?</p>Database Programming: The OPENROWSET Trick, Revisitedhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3215766Fri, 20 Mar 2009 19:08:28 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3215766Ward Pond's SQL Server blog<p>One of the most popular posts in the history of this little corner of the Internets is one from August,</p> http://sqlteam.com/forums/topic.asp?topic_id=70626&whichpage=2http://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3278348Mon, 31 Aug 2009 23:42:51 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3278348TrackBackhttp://dbforums.com/microsoft-sql-server/1647218-processing-result-table-sp-select.htmlhttp://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3283649Tue, 29 Sep 2009 03:37:37 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3283649TrackBackhttp://sqlteam.com/forums/topic.asp?topic_id=131600http://blogs.technet.com/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx#3283650Tue, 29 Sep 2009 03:37:50 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3283650TrackBack