>>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?
>
>You could try TOP 1 in your SQL, just make sure the ORDER is right for it...
That worked wonders - Thanks!!
Jeff Pearce