Post reply

The Bowling Challenge

  • July 24, 2005 at 2:09 pm

    #576636

    I saw this question posted before and I didn't see an answer to it.  In the article it has the following insert statements:

    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 shouldn't the last two be (1, 2, 4), instead of (1, 1, 4).  Is it a typo?
    Thanks, Adam

  • July 25, 2005 at 4:16 am

    #576698

    I thought the point of the challenge was to write a Sp that returned the results of a bowling game, not entering the scores.

    I agree with some comments above, there should be a GameId in the table so you know which game you are scoring against.

    I also feel it would be valid to have a shot number column, which would make less work for the stored procedure when working out the scoring.

    The scoring in bowling is worked out based on the next shot.. we can work that out using the DateAdded column but that will only work if the shots are added in date order..

    ???

    There are a few holes in the Spec here! 

  • July 25, 2005 at 6:55 am

    #576741

    Where do I post my solution to ?

    Im all done now.

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply