11/18/09 "Metro" NY page 16 HARD --> 1 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '017360009'
from sysibm.sysdummy1
union all
select 2, '500027801'
from sysibm.sysdummy1
union all
select 3, '009000000'
from sysibm.sysdummy1
union all
select 4, '058200000'
from sysibm.sysdummy1
union all
select 5, '060000020'
from sysibm.sysdummy1
union all
select 6, '000004170'
from sysibm.sysdummy1
union all
select 7, '000000900'
from sysibm.sysdummy1
union all
select 8, '105740002'
from sysibm.sysdummy1
union all
select 9, '900036710'
from sysibm.sysdummy1
)
Quote:
Sudoku Line
X1736XXX9
5XXX278X1
XX9XXXXXX
X582XXXXX
X6XXXXX2X
XXXXX417X
XXXXXX9XX
1X574XXX2
9XXX3671X
Line 1: | 8 | 1 | 7 | 3 | 6 | 5 | 2 | 4 | 9 |
Line 2: | 5 | 4 | 6 | 9 | 2 | 7 | 8 | 3 | 1 |
Line 3: | 3 | 2 | 9 | 4 | 1 | 8 | 5 | 6 | 7 |
Line 4: | 4 | 5 | 8 | 2 | 7 | 1 | 3 | 9 | 6 |
Line 5: | 7 | 6 | 1 | 8 | 9 | 3 | 4 | 2 | 5 |
Line 6: | 2 | 9 | 3 | 6 | 5 | 4 | 1 | 7 | 8 |
Line 7: | 6 | 7 | 4 | 1 | 8 | 2 | 9 | 5 | 3 |
Line 8: | 1 | 3 | 5 | 7 | 4 | 9 | 6 | 8 | 2 |
Line 9: | 9 | 8 | 2 | 5 | 3 | 6 | 7 | 1 | 4 |
|
Lenny