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?