apatel 80451 (1/11/2012)
Apologies forget to say how I could group the distinct users and there top GWP?
Which column is GWP (I have no idea what GWP is by the way)? It would save time here if you could also show the output you are expecting.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi