Increment sequence
Posted: Tue Nov 25, 2008 12:45 am
hi
I have to increment a integer field coloumn value by one if the there is a duplicate row.
Ex:INPUT(COLA,COLB,COLC ,COLD--KEY COLUMNS)
COLA COLB COLC COLD
-----------------------------------
111 EEE 8XX SSSS
222 AAA 9XX SGDH
222 AAA 9XX HUDG
222 AAA 9XX INKH
333 KKK 7XX HJHJ
333 KKK 7XX JHLJ
333 III 6XX JKKK
OUTPUT:(COLA,COLB,COLC,INT---KEY COLOUMNS)
COLA COLB COLC INT
-----------------------------------
111 EEE 8XX 1
222 AAA 9XX 1
222 AAA 9XX 2
222 AAA 9XX 3
333 KKK 7XX 1
333 KKK 7XX 2
333 III 6XX 1
please give me some sujestions.
I have to increment a integer field coloumn value by one if the there is a duplicate row.
Ex:INPUT(COLA,COLB,COLC ,COLD--KEY COLUMNS)
COLA COLB COLC COLD
-----------------------------------
111 EEE 8XX SSSS
222 AAA 9XX SGDH
222 AAA 9XX HUDG
222 AAA 9XX INKH
333 KKK 7XX HJHJ
333 KKK 7XX JHLJ
333 III 6XX JKKK
OUTPUT:(COLA,COLB,COLC,INT---KEY COLOUMNS)
COLA COLB COLC INT
-----------------------------------
111 EEE 8XX 1
222 AAA 9XX 1
222 AAA 9XX 2
222 AAA 9XX 3
333 KKK 7XX 1
333 KKK 7XX 2
333 III 6XX 1
please give me some sujestions.