### Solution to June’s Puzzle: Josephus Problem

The Josephus problem is an ancient puzzle that involves a group of 41 men standing in a circle. Going around the circle, every second standing man is executed (one skipped, one executed) until only one man is left standing. Assuming that the positions are numbered 1 through 41, which position should Josephus (one of the men) choose if he could, so that he would be the only one to remain standing? Can you generalize the solution for n men? Write a T-SQL solution that returns the position based on the input number of men @n.

An easy way to find a generic solution to this
puzzle with any number of men is to first solve it
with very small numbers of men (1, 2, 3, and so on),
and to look for a pattern in the results. If you solve
the puzzle for small numbers, you get the results
shown in Web Table A (www.sqlmag.com, InstantDoc
ID 99039), where *n* is the number of men, and p is
the position of the only man left.

The pattern you can identify is that p is an increasing
sequence of odd integers that restarts from 1
when *n* is a power of 2. You express n as 2^a + b,
where b >= 0 and b < 2^a. That is, a is the highest
power of 2 such that 2^a is smaller than n, and b is n
minus 2^a. Then, p can be expressed as 2b + 1. For
example, for n = 41, you express n as 2^5 + 9. Since
b = 9 and p = 2b + 1, you get p = 19.

Of course, this is just an observation of a pattern based on the cases that were tested. To ensure that the pattern holds for all cases, you need a mathematical proof. You can find such a proof at en.wikipedia.org/wiki/Josephus_problem. The following T-SQL expression calculates p for a given @n:

SET @n = 41;

SELECT 2 * (@n - POWER(2, CAST(LOG(@n)/LOG(2) AS

INT))) + 1 AS p;