Power of DB2 - Page 2

lennykhiger · **Too easy to HARD -** 10-26-2009, 10:20 PM

Today "Metro" NY page 21 HARD <-- 0 sec -->

Code:

Source (line, sudoku_str) as 
(
select 1, '730098200'
  from sysibm.sysdummy1
union all
select 2, '900040070'
  from sysibm.sysdummy1
union all
select 3, '000000300'
  from sysibm.sysdummy1
union all 
select 4, '800905460'
  from sysibm.sysdummy1
union all
select 5, '200030007'
  from sysibm.sysdummy1
union all
select 6, '043107002'
  from sysibm.sysdummy1
union all
select 7, '007000000'
  from sysibm.sysdummy1
union all
select 8, '060010004'
  from sysibm.sysdummy1
union all
select 9, '002370086'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

73XX982XX
9XXX4XX7X
XXXXXX3XX
8XX9X546X
2XXX3XXX7
X431X7XX2
XX7XXXXXX
X6XX1XXX4
XX237XX86

Line 1: | 7 | 3 | 6 | 5 | 9 | 8 | 2 | 4 | 1 |
Line 2: | 9 | 1 | 8 | 2 | 4 | 3 | 6 | 7 | 5 |
Line 3: | 5 | 2 | 4 | 7 | 6 | 1 | 3 | 9 | 8 |
Line 4: | 8 | 7 | 1 | 9 | 2 | 5 | 4 | 6 | 3 |
Line 5: | 2 | 5 | 9 | 4 | 3 | 6 | 8 | 1 | 7 |
Line 6: | 6 | 4 | 3 | 1 | 8 | 7 | 9 | 5 | 2 |
Line 7: | 4 | 8 | 7 | 6 | 5 | 2 | 1 | 3 | 9 |
Line 8: | 3 | 6 | 5 | 8 | 1 | 9 | 7 | 2 | 4 |
Line 9: | 1 | 9 | 2 | 3 | 7 | 4 | 5 | 8 | 6 |

Lenny

lennykhiger · **Link to whole query -** 10-31-2009, 12:09 AM

This is much easier to use then 2 parts query:

Sudoku_Solver

Lenny

lennykhiger · **10/03/09 "AM", NY page 28 --> 5 sec <-- -** 11-03-2009, 11:30 PM

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