11/13/09 "Metro" NY page 25 HARD --> 1 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '031004000'
from sysibm.sysdummy1
union all
select 2, '900016000'
from sysibm.sysdummy1
union all
select 3, '006730000'
from sysibm.sysdummy1
union all
select 4, '300090205'
from sysibm.sysdummy1
union all
select 5, '084000730'
from sysibm.sysdummy1
union all
select 6, '209070001'
from sysibm.sysdummy1
union all
select 7, '000057900'
from sysibm.sysdummy1
union all
select 8, '000360004'
from sysibm.sysdummy1
union all
select 9, '000800310'
from sysibm.sysdummy1
)
Result:
Quote:
Sudoku Line
X31XX4XXX
9XXX16XXX
XX673XXXX
3XXX9X2X5
X84XXX73X
2X9X7XXX1
XXXX579XX
XXX36XXX4
XXX8XX31X
Line 1: | 7 | 3 | 1 | 9 | 8 | 4 | 6 | 5 | 2 |
Line 2: | 9 | 5 | 8 | 2 | 1 | 6 | 4 | 7 | 3 |
Line 3: | 4 | 2 | 6 | 7 | 3 | 5 | 1 | 9 | 8 |
Line 4: | 3 | 1 | 7 | 4 | 9 | 8 | 2 | 6 | 5 |
Line 5: | 5 | 8 | 4 | 6 | 2 | 1 | 7 | 3 | 9 |
Line 6: | 2 | 6 | 9 | 5 | 7 | 3 | 8 | 4 | 1 |
Line 7: | 8 | 4 | 3 | 1 | 5 | 7 | 9 | 2 | 6 |
Line 8: | 1 | 7 | 2 | 3 | 6 | 9 | 5 | 8 | 4 |
Line 9: | 6 | 9 | 5 | 8 | 4 | 2 | 3 | 1 | 7 |
|
Lenny