Storing the result of a stored procedure call in a temporary table 
Author Message
 Storing the result of a stored procedure call in a temporary table
Hi!

I have a problem that I believe is easy to solve, I just can't find the
syntax for it.
I run a stored procedure on a SQL Server 2000 that is calling another stored
procedure on a Linked SQL Server 2000. I want to put the returned result
from the sp on the linked server into a temporary table in the calling
procedure but cant get the right syntax. Can anyone help me with this?

Thankful for any help!

Per



Sun, 07 Aug 2005 23:44:35 GMT
 Storing the result of a stored procedure call in a temporary table

Something along the lines of...

CREATE TABLE #temp (col1 ...)

--
- Anith
(Please respond only to newsgroups)



Sun, 07 Aug 2005 23:54:04 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Retrieving result from a stored procedure called within another stored procedure

2. temporary tables in stored procedures/parameter views vs stored procedures

3. Inserting Stored Procedure Results into a Temporary Table

4. Creating a Temporary Table from a Stored Procedure Result Set

5. Inserting a stored procedure result set into a temporary table

6. Results from stored procedure to temporary table?

7. creating temporary table inside VB and call from Stored Procedure

8. Calling Stored Procedure that calls Stored Procedure in ASP

9. Calling a Java Stored Procedure from another Java Stored Stored Procedure

10. using SQL stored procedure results in stored procedure

11. Passing a result set from one stored procedure to another stored procedure

12. Executing a Stored Procedure in a Stored Procedure and selecting on the result


 
Powered by phpBB® Forum Software