Trying To Select Newest Row For Each Category...

Hi everyone -





I am building from the Time Tracker Start Kit, trying to get a better feel for how MS thinks we should do things.





In my editing, I have built a new Stored Procedure, trying to pull the newest entries for a specified person.





I have the following that will return all entries for a specific person, sorted by date, newest first:








SELECT


EntryLogID, TT_EntryLog.Description, Duration, EntryDate, TT_EntryLog.ProjectID AS ProjectID,


TT_EntryLog.CategoryID AS CategoryID, TT_Categories.Abbreviation AS CategoryName, TT_Projects.Name AS ProjectName,


ManagerUserID, TT_Categories.Abbreviation AS CatShortName


FROM


TT_EntryLog


INNER JOIN


TT_Categories


ON


TT_EntryLog.CategoryID = TT_Categories.CategoryID


INNER JOIN


TT_Projects


ON


TT_EntryLog.ProjectID = TT_Projects.ProjectID


WHERE


UserID = @UserID


ORDER BY


EntryDate Desc








This will return something like:








EntryLogId Description Duration EntryDate ProjectID CategoryID CategoryName ProjectName ManagerUserID CatShortName


14Can type date in date... .00 2004-02-04 10:28:00116Pros ITS Project Management App 3 Pros


12Changed "Entry Date"... .00 2004-02-03 13:28:00116Pros ITS Project Management App 3 Pros


13Added default button ... .00 2004-02-03 00:00:00116Pros ITS Project Management App 3 Pros


11Removed hours per p... .00 2004-02-03 00:00:00116Pros ITS Project Management App 3 Pros


6Isn't this cool .00 2004-02-02 00:00:00229Pros Knowledge Base 3 Pros


9Added week-by-week... .00 2004-02-02 00:00:00116Pros ITS Project Management App 3 Pros


10Fixed Update comma... .00 2004-02-02 00:00:00116Pros ITS Project Management App 3 Pros


1Built initial framewor... 6.00 2004-01-30 00:00:00116Pros ITS Project Management App 3 Pros


5Adding up to 8 hours... 2.00 2004-01-30 00:00:00229Pros Knowledge Base 3 Pros


3Debugged - fixed a f... 1.00 2004-01-23 00:00:00229Pros Knowledge Base 3 Pros











What I would like to accomplish is to return only the newest entry for each ProjectID (so in the above example, there would only be 2 entries, EntryID 14 and 6)





Any ideas?





Thanks in advance-