I see Noel and I posted almost identical answers on the first question!

Heres one way to update the values...

--- Have a look at new and old data side by side

select a.[sku#], a.[description], a.[SalesDate], x.[description] as new from

(select *, row_number() over (partition by SKU# order by salesDate desc) as rownum from #) x

inner join # a on a.sku# = x.sku#

where rownum=1

-- Run the update

UPDATE a set a.[description] = x.[description]

from

(select *, row_number() over (partition by SKU# order by salesDate desc) as rownum from #) x

inner join # a on a.sku# = x.sku#

where rownum=1

-- Have a look at new values

select * from #