I've got an issue with a table which has multiple versions of the same key record however some are missing relevant data. I know I could build a cursor to loop through but I thought someone would have a more elegant SQL solution.
123|10000|FL |888 |null
123|10001|null |888 |ABC
Condensed record would be
123|x |FL |888 |ABC
The version number is not relevant on the condensed record.
The actual table contains about 80 fields and has up to 15 versions of the record.