Assigning sequential numbers with some conditions
Posted: Tue Oct 26, 2004 4:43 pm
A configuration table SHOWING THE LIMITS WAS given ...
ITEM_TYPE- Start - End
A - 1000 - 1299-
B - 1300 - 1399-
C - 1400- 1799-
D - 1400- 1799-
E - 1800- 1999-
F - 1800- 1999-
G - 1800- 1999-
H - 1800- 1999--
1 - 2000- 1999-
2 - 2500- 1999-
3 - 2500- 1999-
BASED ON THE (ITEM_TYPE), A SEQUENTIAL NUMBER IS TO BE GENERATED IN A NEW COLUMN (ITEM_ID) STARTING FROM THE VALUE IN COLUMN (START)......
FOR EXAMPLE.....SEE THE TABLE BELOW
IF THE DATA I GET IS ONLY THE FIRST COLUMN( ITEM_TYPE)
THE RESULT MUST BE LIKE IN THE SECOND COLUMN...
THE ITEM_ID MUST BE INCREMENTED BASED ON THE (ITEM_TYPE)....
ITEM_TYPE - ITEM_ID
A -1000
B -1300
C -1400
A - 1001
F -1800
D -1401
F - 1801
1 - 2000
1 - 2001
2 - 2500
3 - 2501
I TRIED USING DIFFERENT STAGE VARIABLES, ROUTINE..FOR INCREMENTING VALUES AND CONNECTED THEM BY "IF THEN ELSE " ETC....I GET WIERD VALUES.....I SEE THAT THE VALUES ARE NOT FOLLOWING THE PREVIOUS VALUE BUT THEY GO TO THE STARTING VALUE....
CAN ANY ONE SUGGEST ME AN IDEA....
I TRIED SEARCHING THE FORUM BUT WAS NOT ABLE TO GET ANY RELATED TOPIC....
ITEM_TYPE- Start - End
A - 1000 - 1299-
B - 1300 - 1399-
C - 1400- 1799-
D - 1400- 1799-
E - 1800- 1999-
F - 1800- 1999-
G - 1800- 1999-
H - 1800- 1999--
1 - 2000- 1999-
2 - 2500- 1999-
3 - 2500- 1999-
BASED ON THE (ITEM_TYPE), A SEQUENTIAL NUMBER IS TO BE GENERATED IN A NEW COLUMN (ITEM_ID) STARTING FROM THE VALUE IN COLUMN (START)......
FOR EXAMPLE.....SEE THE TABLE BELOW
IF THE DATA I GET IS ONLY THE FIRST COLUMN( ITEM_TYPE)
THE RESULT MUST BE LIKE IN THE SECOND COLUMN...
THE ITEM_ID MUST BE INCREMENTED BASED ON THE (ITEM_TYPE)....
ITEM_TYPE - ITEM_ID
A -1000
B -1300
C -1400
A - 1001
F -1800
D -1401
F - 1801
1 - 2000
1 - 2001
2 - 2500
3 - 2501
I TRIED USING DIFFERENT STAGE VARIABLES, ROUTINE..FOR INCREMENTING VALUES AND CONNECTED THEM BY "IF THEN ELSE " ETC....I GET WIERD VALUES.....I SEE THAT THE VALUES ARE NOT FOLLOWING THE PREVIOUS VALUE BUT THEY GO TO THE STARTING VALUE....
CAN ANY ONE SUGGEST ME AN IDEA....
I TRIED SEARCHING THE FORUM BUT WAS NOT ABLE TO GET ANY RELATED TOPIC....