I have been using SQL Server for a number of years, but continue to have problems with getting multiple MAX values out of one table.

What I am trying to do is simple:

I need to find out what the last date of modification was for each item in a product table. That's it.

Does anybody have any ideas?