Please find this excel useful: http://www.freewebs.com/arjundamodar...iqueUpdate.xls
In this if u consider C1, C2 and C3, the C4 is not updated when C1 + C2 + C3 forms a 2nd duplicate record. ie, 1st record will be updated in all cases.. but second or above wont be updated.
Arjun Damodar
Last Activity: Apr 14 '11, 10:06 AM
Joined: Feb 16 '11
Location:
-
How to update 1st record in a set of records with unique constrains?
Hello,
Let below shown be the table which i need to update:
No C1 C2 C3 C4
1 A A A A
2 A A A A
3 A A B A
4 A B A A
5 A B A A
6 A B B A
7 B A A A
8 B A B A
9 B A B A
10 B A B A
11 B B B A
Here record 1 and record 2 are the same and so are the records 4 and 5 and also 8, 9 and 10. In This case what i want is...
No activity results to display
Leave a comment: