Binu or others,
Here is the situation. Lets say I have a table with 5 fields. A "duplicate row" will have the same data in 4 of the fields, while the 5th field (submit date) will be different. What I want to do is display in a T-SQL query all unique records along with the duplicate rows that have the latest submit date.
Any suggestions will be appreciated.