I am running sql 2000 and I want to avoid writing an overly complicated query. I have an audit table that contains an unique ID and then several timestamps that can be stamped in any order. I need to find the timestamp that is the smallest for each unique ID.
ID | TimeStamp1 | TimeStamp2 | TimeStamp3 ....
I need to find the youngest timestamp in the row for each given ID. Any ideas? I have searched online and found solutions to turn the data into what I have, but I need it in the following format
ID | StampValue