11/02/09 "AM", NY very hard (27 start numbers) --> 3 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '004000510'
from sysibm.sysdummy1
union all
select 2, '320000700'
from sysibm.sysdummy1
union all
select 3, '000608004'
from sysibm.sysdummy1
union all
select 4, '608000000'
from sysibm.sysdummy1
union all
select 5, '003751900'
from sysibm.sysdummy1
union all
select 6, '000000205'
from sysibm.sysdummy1
union all
select 7, '700804000'
from sysibm.sysdummy1
union all
select 8, '002000031'
from sysibm.sysdummy1
union all
select 9, '061000400'
from sysibm.sysdummy1
)
Result:
Quote:
Sudoku Line
XX4XXX51X
32XXXX7XX
XXX6X8XX4
6X8XXXXXX
XX37519XX
XXXXXX2X5
7XX8X4XXX
XX2XXXX31
X61XXX4XX
Line 1: | 9 | 8 | 4 | 2 | 7 | 3 | 5 | 1 | 6 |
Line 2: | 3 | 2 | 6 | 1 | 4 | 5 | 7 | 8 | 9 |
Line 3: | 5 | 1 | 7 | 6 | 9 | 8 | 3 | 2 | 4 |
Line 4: | 6 | 5 | 8 | 4 | 2 | 9 | 1 | 7 | 3 |
Line 5: | 2 | 4 | 3 | 7 | 5 | 1 | 9 | 6 | 8 |
Line 6: | 1 | 7 | 9 | 3 | 8 | 6 | 2 | 4 | 5 |
Line 7: | 7 | 3 | 5 | 8 | 1 | 4 | 6 | 9 | 2 |
Line 8: | 4 | 9 | 2 | 5 | 6 | 7 | 8 | 3 | 1 |
Line 9: | 8 | 6 | 1 | 9 | 3 | 2 | 4 | 5 | 7 |
|
P.S. Modified code in an attachment
Lenny