Hi all,
I have the following product table
ID Desc
556 Prod A
556 Prod A
556 Prod A
559 Prod C
559 Prod C
559 Prod C
559 Prod C
987 Prod J
987 Prod J
I need a counter for each ID, and then concat for a NEW ID column as shown below.
ID Desc Line NEW ID
556 Prod A 0 556-0
556 Prod A 1 556-1
556 Prod A 2 556-2
559 Prod C 0 559-0
559 Prod C 1 559-1
559 Prod C 2 559-2
559 Prod C 3 559-3
987 Prod J 0 987-0
987 Prod J 1 987-1
so if i were to add another 556 product, the line would look like:
556 Prod A 3 556-3
Any ideas?