GROUP BY Highest Score Per User

Hi there!





I've got a SPROC that generates a recordset of user vote tallies (they're calculated in a separated SPROC). The user submissions are grouped by a GUID value so as to remain unique for a user's submission (each user can have multiple submissions.





The problem is that the recordset returned displays ALL the users, and I'd like to only select the highest score for each user. So, if I have 500 submissions from 3 users (User1 and User2 submit once each and User3 submits 497 times), the total recordset will have 3 rows - being the highest score per user, discounting the others.





Here's my base query:





SELECT a.UserID,a.Name AS [Name],SUM(b.TotalTally) AS [TotalPoints]


FROM Users a


INNER JOIN Ballots b ON a.UserID = b.UserID


GROUP BY a.UserID, a.Name,b.SubmissionGUID


ORDER BY [TotalPoints] DESC,[Name] ASC





...and I've been able to get the highest vote per user, discounting duplicate entries, by using this:





SELECT a.UserID,MAX(b.TotalTally) AS [TotalPoints]


FROM Users a


INNER JOIN Ballots b ON a.UserID = b.UserID


GROUP BY a.UserID





How can I write combine the two in a nested subquery to display only the top score per user?