Unanswered: Select Multiple Max Values from Multiple Columns
I have a table that contains hundreds of columns with duplicate unique keys (customer ID). I would like to get rid of the duplicates by selecting the row that contains the max values in a number of columns. For each customer, I would like to keep the row that has the max value in date1, date2, date3, date4, date5,.... etc.
The tricky part is there are hundreds of dates I need to check. Is there a way to do this?