Inserting stored procedure results into a temp table

[normiebongos]

I have a SQL Server 6.5 database with a stored procedure on it that can't be changed in any way. I have control over a local SQL Server 7.0 database that has a linked server to the 6.5 server. What I need is the syntax to take the results from the remote stored procedure and store them into a temptable on my local machine.

In essence what I want to do is this...

SELECT * FROM
(exec remote_server.remote_dbs.dbo.sp_remote_proc param)
INTO #mytemptable

Hope someone can help.

Peace,
Norm

 

[habfan]

Here is a samll piece SQL Code that I think is what you are looking for.

TRUNCATE TABLE tmpTable (your table name replaces tmptable)

INSERT INTO tmpTable

SELECT insert your select code

 

[tlbroadbent]

This is the code you need.

insert #mytemptable
exec remote_server.remote_dbs.dbo.sp_remote_proc param