How do I use data from a table on different Server 1

[ssecca]

I need to refer to a table on a different server and database for a stored procedure from the original Server/Database. Can someone assist me with a way to acomplish this?

Thank You

 

[JohnDTampaBay]

You can set up the second server as a linked server, then fully qualify the table name in the query:

select * from Server.Database.Owner.Table

Or use OPENDATASOURCE to link to the server on the fly. Please check out BOL for OPENDATASOURCE; I'd rather not parrot.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[ssecca]

Thank you Opendatasouce is what I was looking for in this case.

 

[JohnDTampaBay]

Glad to be of service. Thanks for the star. Happy coding!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.