11/06/09 "Metro" NY, page 29 HARD --> 1 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '020090800'
from sysibm.sysdummy1
union all
select 2, '600270003'
from sysibm.sysdummy1
union all
select 3, '000006210'
from sysibm.sysdummy1
union all
select 4, '000700008'
from sysibm.sysdummy1
union all
select 5, '702804109'
from sysibm.sysdummy1
union all
select 6, '100009000'
from sysibm.sysdummy1
union all
select 7, '067100000'
from sysibm.sysdummy1
union all
select 8, '800042005'
from sysibm.sysdummy1
union all
select 9, '003050080'
from sysibm.sysdummy1
)
Result:
Quote:
Sudoku Line
X2XX9X8XX
6XX27XXX3
XXXXX621X
XXX7XXXX8
7X28X41X9
1XXXX9XXX
X671XXXXX
8XXX42XX5
XX3X5XX8X
Line 1: | 3 | 2 | 1 | 4 | 9 | 5 | 8 | 6 | 7 |
Line 2: | 6 | 8 | 4 | 2 | 7 | 1 | 9 | 5 | 3 |
Line 3: | 9 | 7 | 5 | 3 | 8 | 6 | 2 | 1 | 4 |
Line 4: | 4 | 9 | 6 | 7 | 1 | 3 | 5 | 2 | 8 |
Line 5: | 7 | 5 | 2 | 8 | 6 | 4 | 1 | 3 | 9 |
Line 6: | 1 | 3 | 8 | 5 | 2 | 9 | 7 | 4 | 6 |
Line 7: | 5 | 6 | 7 | 1 | 3 | 8 | 4 | 9 | 2 |
Line 8: | 8 | 1 | 9 | 6 | 4 | 2 | 3 | 7 | 5 |
Line 9: | 2 | 4 | 3 | 9 | 5 | 7 | 6 | 8 | 1 |
|
Lenny