Puzzles

The following section introduces logic puzzles. You can find the puzzle solutions in the section that follows this one.

Someone once said, "A puzzle is its own reward." Enjoy!

Puzzle 1: Remainders

Find the smallest integer (n) that yields a remainder of i – 1 when divided by i, for any i in the range 2 through 10. That is, n % 2 = 1, n % 3 = 2, n % 4 = 3, . . ., n% 9 = 8, n % 10 = 9, in which the percent sign (%) signifies the T-SQL modulo operator.

Puzzle 2: Round Manhole Covers

Why are manhole (maintenance hole) covers typically round? You might find this a strange topic for a puzzle, but the answer lies purely in logic.

Puzzle 3: Shaking Hands

My wife and I were at a party recently with four other married couples. All the people who didn’t ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Querying now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.