Update lastest record for each key - SQL 
Below is my Data

    Key			Value		Date          STATUS
    001			AAA	         2010-01-01       E
    001            BBB          2010-02-01       E
    001            CCC          2010-03-01       E
    002			XXX			 2010-04-01       E
    002            YYY          2010-05-01       E
    002            ZZZ          2010-06-01       E
    003			HHH			 2010-03-01       E
    003            GGG          2010-04-01       E 

I want to update the lastest record for given key with Status C (Current).

How can this be acheived with Update Statement.

Thanks

Update lastest record for each key - SQL 
===

Below is my Data

    Key			Value		Date          STATUS
    001			AAA	         2010-01-01       E
    001            BBB          2010-02-01       E
    001            CCC          2010-03-01       E
    002			XXX			 2010-04-01       E
    002            YYY          2010-05-01       E
    002            ZZZ          2010-06-01       E
    003			HHH			 2010-03-01       E
    003            GGG          2010-04-01       E 

I want to update the lastest record for given key with Status C (Current).

How can this be acheived with Update Statement.

Thanks
