SPROC design for points-based NCAA bracket management app

[jasonsalas]

I'm building an app to manage the upcoming NCAA March Madness tournament. I'm going to use a third-party control from

http://www.tourneylogic.com

to manage the actual brackets, but I've got a problem in determining the winner for a public pool I'm running.

Basically, I want to select the winner of the pool based on points awarded for correctly picking the winners of the games in each successive round of play. For example: if you correctly pick the first round winners, you get 1 point per game, the second round gets 2 points, the Sweet 16 gets 4 points, the Elite 8 gets 8 points, and the Final Four gets 16 points per game. (Corectly picking the National Championship game winner gets 160+1 points, so that someone picking the every game BUT the final won't possibly have more points than the final game).

I'd like to do this all at the database level, within a single stored procedure. I'll write a simple administrative SPROC to aggregate all users' point totals at the end of the tournament, and then display the final tallies. If anyone has done this before, using a tiered scoring system, I'd appreciate the input.

 

[jasonsalas]

Elaborating a little more, my problem is designing a SPROC that will run through each user's posted picks, check if they picked a winner, and if so, assign a certain number of points - and then sum this whole range of values to assrive at a final tally of points.