Hi,
ok i understand the issue. Your sql arnelgp, is wrong. Because in your solution i am joining 2 tables based on common values, and in this case some of them will not match so there will be empty and as result table will updated as empty. This is not want i want to.
I think that what i want is:
1. Check if whole specific record from ExcelTemTable exists in tblDescription- if yes, do not nothing, if not, add this record to tblDescription
2. Delete all records which not exists in ExcelTempTable and exists in tblDescription.
3. Assign all specific tblDescription records to specific Person.
what is a problem here is that i am "cleaning" tblDescription and TblDescriptionPeople and creating them i can say from scracth.
I do not know it approach is good.
Please help with sqls.
Jacek
