11/18/09: From 3 Newspapers (Very Hard, but very FAST):
Code:
Source (line, sudoku_str) as
(
select 1, '082050000'
from sysibm.sysdummy1
union all
select 2, '030047096'
from sysibm.sysdummy1
union all
select 3, '000100002'
from sysibm.sysdummy1
union all
select 4, '090000300'
from sysibm.sysdummy1
union all
select 5, '520000041'
from sysibm.sysdummy1
union all
select 6, '003000020'
from sysibm.sysdummy1
union all
select 7, '300009000'
from sysibm.sysdummy1
union all
select 8, '450630070'
from sysibm.sysdummy1
union all
select 9, '000070910'
from sysibm.sysdummy1
)
Code:
Line 1: | 7 | 8 | 2 | 9 | 5 | 6 | 1 | 3 | 4 |
Line 2: | 1 | 3 | 5 | 2 | 4 | 7 | 8 | 9 | 6 |
Line 3: | 9 | 4 | 6 | 1 | 8 | 3 | 7 | 5 | 2 |
Line 4: | 6 | 9 | 4 | 5 | 1 | 2 | 3 | 8 | 7 |
Line 5: | 5 | 2 | 7 | 3 | 9 | 8 | 6 | 4 | 1 |
Line 6: | 8 | 1 | 3 | 7 | 6 | 4 | 5 | 2 | 9 |
Line 7: | 3 | 7 | 1 | 8 | 2 | 9 | 4 | 6 | 5 |
Line 8: | 4 | 5 | 9 | 6 | 3 | 1 | 2 | 7 | 8 |
Line 9: | 2 | 6 | 8 | 4 | 7 | 5 | 9 | 1 | 3 |
Code:
Source (line, sudoku_str) as
(
select 1, '498000500'
from sysibm.sysdummy1
union all
select 2, '700086001'
from sysibm.sysdummy1
union all
select 3, '000000000'
from sysibm.sysdummy1
union all
select 4, '009021800'
from sysibm.sysdummy1
union all
select 5, '000000000'
from sysibm.sysdummy1
union all
select 6, '005460700'
from sysibm.sysdummy1
union all
select 7, '000000000'
from sysibm.sysdummy1
union all
select 8, '600970304'
from sysibm.sysdummy1
union all
select 9, '500000027'
from sysibm.sysdummy1
)
Quote:
Line 1: | 4 | 9 | 8 | 2 | 1 | 7 | 5 | 6 | 3 |
Line 2: | 7 | 2 | 3 | 5 | 8 | 6 | 4 | 9 | 1 |
Line 3: | 1 | 5 | 6 | 3 | 9 | 4 | 2 | 7 | 8 |
Line 4: | 3 | 4 | 9 | 7 | 2 | 1 | 8 | 5 | 6 |
Line 5: | 2 | 6 | 7 | 8 | 5 | 3 | 1 | 4 | 9 |
Line 6: | 8 | 1 | 5 | 4 | 6 | 9 | 7 | 3 | 2 |
Line 7: | 9 | 7 | 4 | 1 | 3 | 2 | 6 | 8 | 5 |
Line 8: | 6 | 8 | 2 | 9 | 7 | 5 | 3 | 1 | 4 |
Line 9: | 5 | 3 | 1 | 6 | 4 | 8 | 9 | 2 | 7 |
|
Code:
Source (line, sudoku_str) as
(
select 1, '200090000'
from sysibm.sysdummy1
union all
select 2, '080203100'
from sysibm.sysdummy1
union all
select 3, '301400205'
from sysibm.sysdummy1
union all
select 4, '450000800'
from sysibm.sysdummy1
union all
select 5, '900000004'
from sysibm.sysdummy1
union all
select 6, '002000053'
from sysibm.sysdummy1
union all
select 7, '108007602'
from sysibm.sysdummy1
union all
select 8, '009802070'
from sysibm.sysdummy1
union all
select 9, '000040008'
from sysibm.sysdummy1
)
Quote:
Line 1: | 2 | 6 | 5 | 1 | 9 | 8 | 3 | 4 | 7 |
Line 2: | 7 | 8 | 4 | 2 | 5 | 3 | 1 | 6 | 9 |
Line 3: | 3 | 9 | 1 | 4 | 7 | 6 | 2 | 8 | 5 |
Line 4: | 4 | 5 | 3 | 7 | 2 | 9 | 8 | 1 | 6 |
Line 5: | 9 | 1 | 6 | 3 | 8 | 5 | 7 | 2 | 4 |
Line 6: | 8 | 7 | 2 | 6 | 1 | 4 | 9 | 5 | 3 |
Line 7: | 1 | 4 | 8 | 5 | 3 | 7 | 6 | 9 | 2 |
Line 8: | 5 | 3 | 9 | 8 | 6 | 2 | 4 | 7 | 1 |
Line 9: | 6 | 2 | 7 | 9 | 4 | 1 | 5 | 3 | 8 |
|
Lenny