I have some questions :
- Can there be multiple games for 1 UserId in the table ? And if so, should the procedure only list the score of the last game ?
- The inserts in your article all uses FrameNumber = 1. Is it up to the stored prcoedure to correct this, are is it a copy/paste mistake in the article ?
Bert De Haes
- can we assume that scores are entered in sequence, ie the RowID can be used to get the order that balls were thrown?
- will the table hold the scores for more than one player?
I think the table should also have a GameNumber column so you can track the frames properly for each user if they bowl multiple games on the same day.