12/02/09 "AM" NY page 24 === 26 start numbers === --> 3 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '000305200'
from sysibm.sysdummy1
union all
select 2, '400000000'
from sysibm.sysdummy1
union all
select 3, '000600081'
from sysibm.sysdummy1
union all
select 4, '950000060'
from sysibm.sysdummy1
union all
select 5, '060203040'
from sysibm.sysdummy1
union all
select 6, '030000019'
from sysibm.sysdummy1
union all
select 7, '840009000'
from sysibm.sysdummy1
union all
select 8, '300000805'
from sysibm.sysdummy1
union all
select 9, '006501000'
from sysibm.sysdummy1
)
Quote:
Line 1: | 6 | 8 | 1 | 3 | 4 | 5 | 2 | 9 | 7 |
Line 2: | 4 | 7 | 2 | 9 | 1 | 8 | 6 | 5 | 3 |
Line 3: | 5 | 9 | 3 | 6 | 2 | 7 | 4 | 8 | 1 |
Line 4: | 9 | 5 | 8 | 1 | 7 | 4 | 3 | 6 | 2 |
Line 5: | 1 | 6 | 7 | 2 | 9 | 3 | 5 | 4 | 8 |
Line 6: | 2 | 3 | 4 | 8 | 5 | 6 | 7 | 1 | 9 |
Line 7: | 8 | 4 | 5 | 7 | 3 | 9 | 1 | 2 | 6 |
Line 8: | 3 | 1 | 9 | 4 | 6 | 2 | 8 | 7 | 5 |
Line 9: | 7 | 2 | 6 | 5 | 8 | 1 | 9 | 3 | 4 |
|
Lenny