Two Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: SAMAY (anonymous_at_discussions.microsoft.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 13:41:04 -0700

I have two server

1. Member table name = eMember
2. UMD123 table name = EW_Test

I want to get all those records which do exists in EW_Test but not in efolder(i.e my process is that whenever a user hit Send a record is created in eMember & EW_Test, But for some reason the records were not created in EW_Test which i want to insert it manually)

I have a a below script But this is giving me all the records instead of only Those records which do not exists in EW_Test table

Select E.eName, U.eName from Dbo.eMember E, eMember_app_Test.UMD123.dbo.EW_Test U
where U.eName<> E.eName and E.Salary = '100000'

Please advice me with this

Thanks!!!!!

Relevant Pages

  • Re: Find all server o/s info and write to excel
    ... list of all servers in my domain (dc and member) to excel. ... "Shiloh" wrote: ... I found a simple error in the script. ... either member server or domain controller. ...
    (microsoft.public.windows.server.scripting)
  • Re: validate user in group and go to ok page (adsi ldap)
    ... But a dubt on time when the script run... ... Is possible to insert a loop similar do while server is reday... ... ' User is a member. ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.scripting)
  • RE: remote listing of a local group using another account
    ... these are templates and you need to modify them to suit ... I am trying to write a script which will allow me to list the content ... that server, I will have to use som sort of logon. ... For Each member in group.Members ...
    (microsoft.public.windows.server.scripting)
  • script to copy file to a group of user on windows server
    ... server "gcsserver" and check to see if they are a member of the PSI ... I have never written any script. ...
    (microsoft.public.scripting.vbscript)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
    (perl.beginners)