MS SQL Server Security Tools - how select record from liknked server

Author

how select record from liknked server

Mohd Sufian

2005-03-30, 9:42 am

i am having 2 server for 2 diffrent sites. i had created a linked server on
my local server and now i want to execute a t-sql that those record should be
shown from the linked server table those record r not in my local table.

here i the command i am using for it.

select a.recid from [132.19.0.16].aicnav.dbo.custinvoicetrans
a,dbo.custinvoicetrans b
where a.recid > b.recid

--
waiting for solution
from
Sufian

Sue Hoegemeier

2005-03-30, 9:42 am

select a.recid
from [132.19.0.16].aicnav.dbo.custinvoicetrans a
where not exists
(select *
from dbo.custinvoicetrans b
where a.recid = b.recid)

-Sue

On Tue, 29 Mar 2005 22:47:03 -0800, "Mohd Sufian"
<sufian@aeroflex.co.th> wrote:

>i am having 2 server for 2 diffrent sites. i had created a linked server on
>my local server and now i want to execute a t-sql that those record should be
>shown from the linked server table those record r not in my local table.
>
>here i the command i am using for it.
>
>select a.recid from [132.19.0.16].aicnav.dbo.custinvoicetrans
>a,dbo.custinvoicetrans b
>where a.recid > b.recid

Sponsored Links