Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Rounds INT = 3;
- WITH Slots AS (SELECT 1 AS RecursionLevel, 1 AS Num1, 2 AS Num2
- UNION ALL
- SELECT RecursionLevel + 1 AS RecursionLevel, Num1, POWER(2,RecursionLevel+1) + 1 - Num1
- FROM Slots
- WHERE RecursionLevel < @Rounds
- UNION ALL
- SELECT RecursionLevel + 1 AS RecursionLevel, Num2, POWER(2,RecursionLevel+1) + 1 - Num2
- FROM Slots
- WHERE RecursionLevel < @Rounds)
- SELECT @Rounds + 1 - RecursionLevel AS [Round], Num1, Num2
- FROM Slots
- ORDER BY 1
Add Comment
Please, Sign In to add comment