Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Locating identical player names and adding their scores up into 1 field

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-21 : 10:10:20
Daniel writes "Ok this is (for me) impossible, i hope you can help!

I have a database wanting to find all identical player names and add up all their scores.

Lets say I have 2 players; Greg & Tim they both have 2 record entries and i would like to add up there scores into just 1 record per player. If you can understand that !!!

Name____Score

Greg____5
Tim_____6
Greg____3
Tim_____6


I hope this table makes it clearer.


Many thanks,

Daniel"
   

- Advertisement -