ibrahim

Question

Post reply

ibrahim

ibrahim_sh_87

SSC-Addicted

Points: 451
More actions
March 25, 2009 at 12:58 am

#130045

hey all
i am trying to query from a stored Procedure found from a remote server...and join the results with data found on a table another database.... my sql statment looked like that:
select col1,col2,..,local.colx from openquery(LSname,'exec storedproc') where openquery(LSname,'exec storedproc').colx=local.colx
i know it is wrong..please hel

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sandy-1031461 SSC Enthusiast Points: 172 More actions · Answer 1

Take the output from open query in a temp table..and join this to another ...

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 2

ibrahim_sh_87 (3/25/2009)
hey all
i am trying to query from a stored Procedure found from a remote server...and join the results with data found on a table another database.... my sql statment looked like that:
select col1,col2,..,local.colx from openquery(LSname,'exec storedproc') where openquery(LSname,'exec storedproc').colx=local.colx
i know it is wrong..please hel

use OPENQUERY to get the result, for more information see SQL BOL.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 4

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 5

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

David Burrows SSC Guru Points: 65142 More actions · Answer 6

Not sure what the 'local' is supposed to be or where col1,col2 are but is this what you are trying to do ?

SELECT col1,col2,l.colx

FROM [localtable] l

INNER JOIN OPENQUERY(LSname,'exec storedproc') r ON r.colx=l.colx

Far away is close at hand in the images of elsewhere.
Anon.