Re: How to get rid of double records (SQL) - HELP!
suggest you do it first in excel, much simpler.
after coming to the final result, 1 record per partno+max date, then you can
create a link table in msa and use this link table instead of building a slow query.
"Never stop learning, because life never stops teaching"