problem with updating record using xml

hi,
i have the following tables
client
clientID IDENTITY
FirstName
LastName
AddressId
Contact
AddressID
address1
address2
city
state
country
i have two system S1 and S2 , both will be in a different places.
both s1 and s2 can add client data. remember clientId is identity field.
once in a interval S2 will generate a xml file and upload into a server
(third system
S3) now S1 will get the XML file from S3 i.e. server.
now S1 has to update all those records from XML which is sent by S2.
the problem is both S1 and S2 would have clientID with same id but with
different
informations.
if i update records in S1 using ClientID from S2, then records which have same
ID will get affected.
in this scanario how can i update records in S1...
after some days again S2 will upload xml file , and that file should also
be updated again without affecting records entered in S1.
can anyone help in this regard
Hi Thiru,
It really depends on how you've implemented the process. Please provide more
details of what technology you are using to achieve this.
thanks
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Thiru.S" <Thiru.S@.discussions.microsoft.com> wrote in message
news:F5AE4559-8377-4E0D-8C1A-CD7B5820ED67@.microsoft.com...
> hi,
> i have the following tables
> client
> --
> clientID IDENTITY
> FirstName
> LastName
> AddressId
> Contact
> --
> AddressID
> address1
> address2
> city
> state
> country
>
> i have two system S1 and S2 , both will be in a different places.
> both s1 and s2 can add client data. remember clientId is identity field.
> once in a interval S2 will generate a xml file and upload into a server
> (third system
> S3) now S1 will get the XML file from S3 i.e. server.
> now S1 has to update all those records from XML which is sent by S2.
> the problem is both S1 and S2 would have clientID with same id but with
> different
> informations.
> if i update records in S1 using ClientID from S2, then records which have
> same
> ID will get affected.
> in this scanario how can i update records in S1...
> after some days again S2 will upload xml file , and that file should also
> be updated again without affecting records entered in S1.
> can anyone help in this regard
>
>
>