Can you explain what are you trying to do?

>Hello All, can anyone explain why the following SP doesn't insert any records ?, the dbo.ListNos table can be empty but the linked server always has records.
>
>

>ALTER     PROCEDURE BatchUpdateListNos
> AS
>Insert into dbo.ListNos
>Select li_no As AdmitList,lux_or_uk As LuxOrUK
>From lcsshare...ListNos t1 ,dbo.ListNos t2
>Where t2.AdmitList
>Not in
>(Select li_no From lcsshare...ListNos)
>