10/04/09 "Metro" NY page 19, HARD --> 3 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '080000000'
from sysibm.sysdummy1
union all
select 2, '213005000'
from sysibm.sysdummy1
union all
select 3, '006009102'
from sysibm.sysdummy1
union all
select 4, '042090701'
from sysibm.sysdummy1
union all
select 5, '000812000'
from sysibm.sysdummy1
union all
select 6, '501040820'
from sysibm.sysdummy1
union all
select 7, '604700200'
from sysibm.sysdummy1
union all
select 8, '000900674'
from sysibm.sysdummy1
union all
select 9, '000000010'
from sysibm.sysdummy1
)
Result:
Quote:
Sudoku Line
X8XXXXXXX
213XX5XXX
XX6XX91X2
X42X9X7X1
XXX812XXX
5X1X4X82X
6X47XX2XX
XXX9XX674
XXXXXXX1X
Line 1: | 4 | 8 | 9 | 1 | 2 | 6 | 5 | 3 | 7 |
Line 2: | 2 | 1 | 3 | 4 | 7 | 5 | 9 | 8 | 6 |
Line 3: | 7 | 5 | 6 | 3 | 8 | 9 | 1 | 4 | 2 |
Line 4: | 8 | 4 | 2 | 5 | 9 | 3 | 7 | 6 | 1 |
Line 5: | 3 | 6 | 7 | 8 | 1 | 2 | 4 | 5 | 9 |
Line 6: | 5 | 9 | 1 | 6 | 4 | 7 | 8 | 2 | 3 |
Line 7: | 6 | 3 | 4 | 7 | 5 | 1 | 2 | 9 | 8 |
Line 8: | 1 | 2 | 5 | 9 | 3 | 8 | 6 | 7 | 4 |
Line 9: | 9 | 7 | 8 | 2 | 6 | 4 | 3 | 1 | 5 |
|
Lenny