The Bowling Challenge

• Tom Henley

  SSC Enthusiast

  Points: 119

  More actions

  July 23, 2004 at 5:54 am

  #162322

  Andy ... in your article you populate the bowling score table with the following data:

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  but your article expects the score to be reported by frame.  Your data is all for the first frame, acording to the table schema.  Would this be more along the lines of what you meant:

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 1, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 2, 4)

  Insert into Scores (UserID, FrameNumber, NumberOfPins) Values (1, 2, 4)

  ?

   

  Also, since we have an identity column on the table, I assume we are supposed to use that to determine the ball number in the frame, because if the bower has a spare in the 3rd frame, and rolls a 7 on the first ball and a 2 on the second ball in the 4th frame, he should receive credit for 17 pins and not 12 (spare is 10 pin count from the spare plus the count on the 1st ball in the next frame.)  True or False ?

   

  Thanks

  Tom

• July 26, 2004 at 8:00 am

  This was removed by the editor as SPAM