11/17/09 "Metro" page 24 HARD --> 1 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '041705098'
from sysibm.sysdummy1
union all
select 2, '050308000'
from sysibm.sysdummy1
union all
select 3, '000040000'
from sysibm.sysdummy1
union all
select 4, '205000031'
from sysibm.sysdummy1
union all
select 5, '900000005'
from sysibm.sysdummy1
union all
select 6, '170000802'
from sysibm.sysdummy1
union all
select 7, '000030000'
from sysibm.sysdummy1
union all
select 8, '000107020'
from sysibm.sysdummy1
union all
select 9, '410602750'
from sysibm.sysdummy1
)
Code:
Sudoku Line
X417X5X98
X5X3X8XXX
XXXX4XXXX
2X5XXXX31
9XXXXXXX5
17XXXX8X2
XXXX3XXXX
XXX1X7X2X
41X6X275X
Line 1: | 3 | 4 | 1 | 7 | 2 | 5 | 6 | 9 | 8 |
Line 2: | 6 | 5 | 9 | 3 | 1 | 8 | 2 | 4 | 7 |
Line 3: | 7 | 8 | 2 | 9 | 4 | 6 | 5 | 1 | 3 |
Line 4: | 2 | 6 | 5 | 8 | 7 | 4 | 9 | 3 | 1 |
Line 5: | 9 | 3 | 8 | 2 | 6 | 1 | 4 | 7 | 5 |
Line 6: | 1 | 7 | 4 | 5 | 9 | 3 | 8 | 6 | 2 |
Line 7: | 5 | 2 | 7 | 4 | 3 | 9 | 1 | 8 | 6 |
Line 8: | 8 | 9 | 6 | 1 | 5 | 7 | 3 | 2 | 4 |
Line 9: | 4 | 1 | 3 | 6 | 8 | 2 | 7 | 5 | 9 |
Lenny