SQL Server Performance Forum – Threads Archive
Capturing output
<br />I want to capture the output of a Sp which returns a recordset. One way of doing it is to create a temporary table and execute the Sp with Insert. <br /><br />Create #temp1 (col1 int, col2 int)<br /><br />Insert into #temp1<br /> (col1 int, col2 int)<br />Execute <SpName> <<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ara1>, <<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ara2><br /><br />Is there any other way of doing it?. <br />http://www.databasejournal.com/features/mssql/article.php/3386661
]]>