10/03/09 "AM" page 28 --> 5 sec <--
Code:
Source (line, sudoku_str) as
(
select 1, '100009000'
from sysibm.sysdummy1
union all
select 2, '508000903'
from sysibm.sysdummy1
union all
select 3, '200830000'
from sysibm.sysdummy1
union all
select 4, '001070500'
from sysibm.sysdummy1
union all
select 5, '007204600'
from sysibm.sysdummy1
union all
select 6, '009080100'
from sysibm.sysdummy1
union all
select 7, '000093006'
from sysibm.sysdummy1
union all
select 8, '904000805'
from sysibm.sysdummy1
union all
select 9, '000700004'
from sysibm.sysdummy1
)
Result:
Quote:
Sudoku Line
1XXXX9XXX
5X8XXX9X3
2XX83XXXX
XX1X7X5XX
XX72X46XX
XX9X8X1XX
XXXX93XX6
9X4XXX8X5
XXX7XXXX4
Line 1: | 1 | 4 | 3 | 5 | 6 | 9 | 7 | 8 | 2 |
Line 2: | 5 | 7 | 8 | 1 | 4 | 2 | 9 | 6 | 3 |
Line 3: | 2 | 9 | 6 | 8 | 3 | 7 | 4 | 5 | 1 |
Line 4: | 3 | 2 | 1 | 9 | 7 | 6 | 5 | 4 | 8 |
Line 5: | 8 | 5 | 7 | 2 | 1 | 4 | 6 | 3 | 9 |
Line 6: | 4 | 6 | 9 | 3 | 8 | 5 | 1 | 2 | 7 |
Line 7: | 7 | 8 | 5 | 4 | 9 | 3 | 2 | 1 | 6 |
Line 8: | 9 | 3 | 4 | 6 | 2 | 1 | 8 | 7 | 5 |
Line 9: | 6 | 1 | 2 | 7 | 5 | 8 | 3 | 9 | 4 |
|
Lenny