Processing Groups

Essentially I have a table like this:

KEYVAR     X       Y


======     =       =

A          1       .
A          1       .
B          1       .
C          1       .
C          1       .
C          1       .

and want to make Y equal 1 on the first occurance of the a new KEYVAR group ie like:

KEYVAR     X       Y


======     =       =

A          1       1
A          1       .
B          1       1
C          1       1
C          1       .
C          1       .

How can I do this using SQL?

Regards
Lindsay Walton Received on Tue Dec 11 2001 - 03:46:21 CST