• If I add Quantity to the equation, the data looks like this :

    SKU# Description Date Quantity RN

    01110Red Car with laser2009-02-25 00:00:00.00031

    01110Red Car with line 2009-02-01 00:00:00.00032

    01110Red Car with stripe2009-01-19 00:00:00.00033

    01120Blue Car with laser2009-02-20 00:00:00.00031

    01120Blue Car with line 2009-02-05 00:00:00.00022

    01120Blue Car with stripe2009-01-19 00:00:00.00023

    How can I change all descriptions for a particular sku to the newest description, so the data looks like this: I need to keep the daily sales quantity.

    SKU# Description Date Quantity RN

    01110Red Car with laser2009-02-25 00:00:00.00031

    01110Red Car with laser2009-02-01 00:00:00.00032

    01110Red Car with laser2009-01-19 00:00:00.00033

    01120Blue Car with laser2009-02-20 00:00:00.00031

    01120Blue Car with laser 2009-02-05 00:00:00.00022

    01120Blue Car with laser2009-01-19 00:00:00.00023