I have the following data in a sql server 2005 table:
team score week win loss team1 100 1 team2 120 1 team3 130 1 team4 80 1 team5 90 1
I want to update the win & loss columns so that each team has results compared to all other scores that week, so team1 would show 2 wins, 2 losses, team2 would have 3 wins, 1 loss, etc. Ever week the scores would be inputted and I want the wins and losses calculated.
How do I go about this? It is a small database.