>Ok... I got it now with completing your good stuff with this...
>
>SELECT max(Week)
>FROM MySQLTable t1
>WHERE Sku = '7163910'
>and Store = '037'
>and NOT EXISTS
>(SELECT * FROM MySQLTable t2
>WHERE t2.Sku = t1.Sku
>AND t2.Store = t1.Store
>AND t2.TotalSalesUnits > t1.TotalSalesUnits)
>
>Thank you Sergey and Happy New Year!!!
You're welcome and Happy New Year!
--sb--