LtCmdrData
Technical User
- Jan 4, 2008
- 11
How can i ask this with seming a little dense, i am however bashing my head against the desk in frustration. i have a table of data containing multiple unique customer id numbers and multiple non unique business codes, i also have a URN applied to each record in the database. What i need to do is flag where there is a duplication of the business codes and apply the customer id into a new field. that was the simple partwhat i need to do as well is where there is a duplicate apply only the customer id from the lowest number URN. Effectivley end up with something like this.
URN CUST_ID BUS_ID DUPE_CUST_ID
1 a 1 a
2 b 2 b
3 c 3 c
4 d 3 c
5 e 4 e
6 f 4 e
7 g 4 e
8 h 1 a
9 i 5 i
Any help at all would be appreciated.
URN CUST_ID BUS_ID DUPE_CUST_ID
1 a 1 a
2 b 2 b
3 c 3 c
4 d 3 c
5 e 4 e
6 f 4 e
7 g 4 e
8 h 1 a
9 i 5 i
Any help at all would be appreciated.