I have a cursor which is populated using a select sql. Here is a typical view of the table:

Fabric                   Supplier               Artikey                   Rating
---------                ----------             ----------                --------
Zoom                     Ozbucek                F*000001                  1.29
TMI                      TMI                    F*002345                  0.21
Yao Hung                 Exquisite              F*002134                  1.21
Zoom                     Ozbucek                F*000001                  0.89

What I would like to do is if there are duplicate records I want to just have one record and add the rating of any duplicates. For example my new cursor would see that there is more than 1 artikey with the same artikey so it would add the rating of the second occurence to the first record then delete any duplicates. My new cursor would like:

Fabric                   Supplier               Artikey                   Rating
---------                ----------             ----------                --------
Zoom                     Ozbucek                F*000001                  2.18
TMI                      TMI                    F*002345                  0.21
Yao Hung                 Exquisite              F*002134                  1.21

Is this possible to do?

Many Thanks