I'm at-a-loss trying to compare two table rows with the same ID.
I need to update the 'IsPriceChg' in the row where Price column data is greater.
I tried using Select 'Top 1' ...
ID [Date] IsPriceChg Harmonica
88 2012-07-29 00:00:00.000 NULL 1.00
88 2012-07-30 00:00:00.000 NULL 2.00
I have this much, but not working yet:
Set IsPriceChg = 1
where ListID = 88
and max([Harmonica]) > min([Harmonica])