Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicbutler
Starting Member
2 Posts |
 Posted - 2006-05-02 : 09:53:45
|
| Hi,I've got access to a third party stored procedure that returns two tables. How can I populate a temporary table from the second returned table? The following does not work as there are two output tables:insert INTO #tmp execute sp_DemoThanks in advance,Nic |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-02 : 10:08:04
|
| The easiest way would be to get the third party to modify it - is that possible?Kristen |
 |
|
|
nicbutler
Starting Member
2 Posts |
Posted - 2006-05-02 : 10:12:21
|
| Sadly not. |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-05-02 : 11:06:53
|
| If the stored procedure returns 2 distinct result sets, then I think the only way that you could do what you want to do is to write a .DLL using API level calls to get the data, and then create an extended stored procedure for that .DLL.Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
|
|
|
|
|
|
Create Temp Table from SP second table