Re: combining data on different sevvers
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Thu, 10 Aug 2006 08:37:10 -0700
Yes, quite possible. Subject to the security on both servers allowing such action.
Syntax is somewhat like this:
SELECT
a.Column1
, a.Column2
, b.Column5
, b.Column6
FROM Server1.MyDatabase.dbo.MyTable a
JOIN Server2.OtherDatabase.dbo.OtherTable b
ON a.KeyColumn = b.KeyColumn
WHERE ( a.CriteriaColumn = CriteriaA
AND b.CriteraColumn = CriteriaB
)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Charles MacLean" <charlesmaclean@xxxxxxxxxxxxx> wrote in message news:XIGCg.9735$gY6.3907@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need to combine data from two different tables on two MS SQL servers
running on the same LAN into a single SELECT or VIEW. Is this possible and
what would the syntax look like?
Thanks,
Charles
MTS, Inc.
- References:
- combining data on different sevvers
- From: Charles MacLean
- combining data on different sevvers
- Prev by Date: Re: SQLServer Connection Problems...
- Next by Date: NIC settings for SQL 2005 and windows 2003?
- Previous by thread: combining data on different sevvers
- Next by thread: NIC settings for SQL 2005 and windows 2003?
- Index(es):
Relevant Pages
|
Loading
