In my search for faster processing speeds I have used a SQL statement to search a table of 500k records and group it on a part number. My problem comes when I review the results and find that the SQL statement did not give me the latest price for that item. I have tried using MAX(date), order by date desc, and a straight SQL statement to no avail. Any ideas on how to output the right record?

Thanks in advance,
Jeff Pearce