Monday Sudoku: Total time - 2 sec
Code:
Source (line, sudoku_str) as
(
select 1, '032000106'
from sysibm.sysdummy1
union all
select 2, '080605000'
from sysibm.sysdummy1
union all
select 3, '000030000'
from sysibm.sysdummy1
union all
select 4, '093008000'
from sysibm.sysdummy1
union all
select 5, '240000087'
from sysibm.sysdummy1
union all
select 6, '000200040'
from sysibm.sysdummy1
union all
select 7, '000020000'
from sysibm.sysdummy1
union all
select 8, '060803020'
from sysibm.sysdummy1
union all
select 9, '100000750'
from sysibm.sysdummy1
)
Quote:
Line 1: | 5 | 3 | 2 | 9 | 8 | 4 | 1 | 7 | 6 |
Line 2: | 9 | 8 | 1 | 6 | 7 | 5 | 2 | 3 | 4 |
Line 3: | 6 | 7 | 4 | 1 | 3 | 2 | 8 | 9 | 5 |
Line 4: | 7 | 9 | 3 | 5 | 4 | 8 | 6 | 1 | 2 |
Line 5: | 2 | 4 | 6 | 3 | 1 | 9 | 5 | 8 | 7 |
Line 6: | 8 | 1 | 5 | 2 | 6 | 7 | 3 | 4 | 9 |
Line 7: | 3 | 5 | 9 | 7 | 2 | 1 | 4 | 6 | 8 |
Line 8: | 4 | 6 | 7 | 8 | 5 | 3 | 9 | 2 | 1 |
Line 9: | 1 | 2 | 8 | 4 | 9 | 6 | 7 | 5 | 3 |
|
Code:
Source (line, sudoku_str) as
(
select 1, '046308002'
from sysibm.sysdummy1
union all
select 2, '000020300'
from sysibm.sysdummy1
union all
select 3, '000000960'
from sysibm.sysdummy1
union all
select 4, '800001040'
from sysibm.sysdummy1
union all
select 5, '390602015'
from sysibm.sysdummy1
union all
select 6, '060800003'
from sysibm.sysdummy1
union all
select 7, '013000000'
from sysibm.sysdummy1
union all
select 8, '005080000'
from sysibm.sysdummy1
union all
select 9, '400705230'
from sysibm.sysdummy1
)
Quote:
Line 1: | 7 | 4 | 6 | 3 | 9 | 8 | 1 | 5 | 2 |
Line 2: | 9 | 5 | 8 | 1 | 2 | 6 | 3 | 7 | 4 |
Line 3: | 1 | 3 | 2 | 4 | 5 | 7 | 9 | 6 | 8 |
Line 4: | 8 | 2 | 7 | 5 | 3 | 1 | 6 | 4 | 9 |
Line 5: | 3 | 9 | 4 | 6 | 7 | 2 | 8 | 1 | 5 |
Line 6: | 5 | 6 | 1 | 8 | 4 | 9 | 7 | 2 | 3 |
Line 7: | 2 | 1 | 3 | 9 | 6 | 4 | 5 | 8 | 7 |
Line 8: | 6 | 7 | 5 | 2 | 8 | 3 | 4 | 9 | 1 |
Line 9: | 4 | 8 | 9 | 7 | 1 | 5 | 2 | 3 | 6 |
|
Lenny