Absolute SUDOKU Solver - Page 3

Lenny77 · #31 (**permalink**) 10-16-09, 14:19

Please, take a look on this Input:

Code:

Source (line, sudoku_str) as 
(
select 1, '860020000'
  from sysibm.sysdummy1
union all
select 2, '000700059'
  from sysibm.sysdummy1
union all
select 3, '000000000'
  from sysibm.sysdummy1
union all 
select 4, '000060800'
  from sysibm.sysdummy1
union all
select 5, '040000000'
  from sysibm.sysdummy1
union all
select 6, '005300007'
  from sysibm.sysdummy1
union all
select 7, '000000000'
  from sysibm.sysdummy1
union all
select 8, '020000600'
  from sysibm.sysdummy1
union all
select 9, '007509000'
  from sysibm.sysdummy1
)

This is SUPER HARD Sudoku.

Only 17 start numbers, two empty horisontal lines, etc.

For this kind of Sudoku, only, if you'll find them somewhere (very seldom in real) you have to execute code from attachment
(SUDOKU_Solver_v7_Super_Hard.txt).

I didn't make any changes to the logics, but for design.
My goal was performance, I did not thik about how it look, in this case.

Result will look not so nice like with the regular level sudokus.

For any other levels you don't need to execute this code, but code which I gave to you before
(Absolute_SUDOKU_Solver_v5_Weight.txt).

Lenny Khiger, ADSPA&VP

Lenny77 · #32 (**permalink**) 10-16-09, 18:21

This is the Minimal Sudoku solved by Super Hard Solver.
We have nothing in Source. All zeroes.

Take a look on result !

Quote:

Source (line, sudoku_str) as
(
select 1, '000000000'
from sysibm.sysdummy1
union all
select 2, '000000000'
from sysibm.sysdummy1
union all
select 3, '000000000'
from sysibm.sysdummy1
union all
select 4, '000000000'
from sysibm.sysdummy1
union all
select 5, '000000000'
from sysibm.sysdummy1
union all
select 6, '000000000'
from sysibm.sysdummy1
union all
select 7, '000000000'
from sysibm.sysdummy1
union all
select 8, '000000000'
from sysibm.sysdummy1
union all
select 9, '000000000'
from sysibm.sysdummy1
)

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

Lenny

Lenny77 · #33 (**permalink**) 10-19-09, 11:50

NY Post (today), page 18 (difficult #1327):

Sudoku Line

XX7XXXXX1
XX27X69XX
1X4XXXXXX
X1X6XX2X5
2XXX4XXX3
7X5XX8X9X
XXXXXX8X4
XX18X53XX
9XXXXX1XX

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

Lenny

Lenny77 · #34 (**permalink**) 10-19-09, 12:21

Please use the last two queries..

Where Absolute_SUDOKU_Solver_v5_Weight.txt for any from easy to very hard,

SUDOKU_Solver_v7_Super_Hard.txt for Super Hard with the startnumbers less then 25, or which markes as superhard.

Lenny

Lenny77 · #35 (**permalink**) 10-20-09, 15:13

Easy - 0 sec

Quote:

Sudoku Line

XXX8X4X36
XXXXX1X9X
XXXXXX542
XX7X19XX3
X84XXX21X
6XX32X7XX
239XXXXXX
X4X5XXXXX
71X6X3XXX

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

Hard - 5 sec

Quote:

Sudoku Line

1X47XXXXX
XX8X64X5X
5XX81XXXX
XX9X27XX4
8XXXXXXX5
7XX68X9XX
XXXX76XX2
X6X49X1XX
XXXXX84X6

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

Lenny

Lenny77 · #36 (**permalink**) 10-21-09, 11:04

Today "AM", NY, page 37, level-3 (5 sec):

Quote:

Sudoku Line

XXX7X2X1X
XX6XXX58X
3XX1XXXX2
7XX6X5XXX
XX3XXX4XX
XXX2X9XX3
9X2XX8XX1
X58XXXXXX
XXX4XXXXX

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

Lenny

Lenny77 · #37 (**permalink**) 10-22-09, 10:50

Today "AM" NY page 33, level-3 5 sec.

I want give to not just solution, as usual, but a Source part.
You can replace your Source part by this

Code:

Source (line, sudoku_str) as 
(
select 1, '000010603'
  from sysibm.sysdummy1
union all
select 2, '200000010'
  from sysibm.sysdummy1
union all
select 3, '067380004'
  from sysibm.sysdummy1
union all 
select 4, '400900005'
  from sysibm.sysdummy1
union all
select 5, '080000060'
  from sysibm.sysdummy1
union all
select 6, '000008009'
  from sysibm.sysdummy1
union all
select 7, '500093280'
  from sysibm.sysdummy1
union all
select 8, '010000006'
  from sysibm.sysdummy1
union all
select 9, '803070000'
  from sysibm.sysdummy1
)

and get solution on your machine in seconds:

Quote:

Sudoku Line

XXXX1X6X3
2XXXXXX1X
X6738XXX4
4XX9XXXX5
X8XXXXX6X
XXXXX8XX9
5XXX9328X
X1XXXXXX6
8X3X7XXXX

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

Lenny

Lenny77 · #38 (**permalink**) 10-23-09, 11:43

Today "AM" NY page 32, level-4 <-- 10 sec -->

Code:

Source (line, sudoku_str) as 
(
select 1, '000100000'
  from sysibm.sysdummy1
union all
select 2, '000609500'
  from sysibm.sysdummy1
union all
select 3, '302000004'
  from sysibm.sysdummy1
union all 
select 4, '001080700'
  from sysibm.sysdummy1
union all
select 5, '600000002'
  from sysibm.sysdummy1
union all
select 6, '008030900'
  from sysibm.sysdummy1
union all
select 7, '500000601'
  from sysibm.sysdummy1
union all
select 8, '006300200'
  from sysibm.sysdummy1
union all
select 9, '800007400'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XXX1XXXXX
XXX6X95XX
3X2XXXXX4
XX1X8X7XX
6XXXXXXX2
XX8X3X9XX
5XXXXX6X1
XX63XX2XX
8XXXX74XX

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

Today "Metro" NY page 20 HARD <-- 1 sec -->

Code:

Source (line, sudoku_str) as 
(
select 1, '000780010'
  from sysibm.sysdummy1
union all
select 2, '000305860'
  from sysibm.sysdummy1
union all
select 3, '080021300'
  from sysibm.sysdummy1
union all 
select 4, '017000500'
  from sysibm.sysdummy1
union all
select 5, '800000006'
  from sysibm.sysdummy1
union all
select 6, '004000120'
  from sysibm.sysdummy1
union all
select 7, '001260080'
  from sysibm.sysdummy1
union all
select 8, '043809000'
  from sysibm.sysdummy1
union all
select 9, '020034000'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XXX78XX1X
XXX3X586X
X8XX213XX
X17XXX5XX
8XXXXXXX6
XX4XXX12X
XX126XX8X
X438X9XXX
X2XX34XXX

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

Lenny

Lenny77 · #39 (**permalink**) 10-26-09, 11:41

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

Lenny77 · #40 (**permalink**) 10-26-09, 11:43

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

Lenny77 · #41 (**permalink**) 10-26-09, 11:43

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

Code:

Source (line, sudoku_str) as 
(
select 1, '075000430'
  from sysibm.sysdummy1
union all
select 2, '300090006'
  from sysibm.sysdummy1
union all
select 3, '014007000'
  from sysibm.sysdummy1
union all 
select 4, '200500080'
  from sysibm.sysdummy1
union all
select 5, '140030092'
  from sysibm.sysdummy1
union all
select 6, '030004007'
  from sysibm.sysdummy1
union all
select 7, '000600270'
  from sysibm.sysdummy1
union all
select 8, '800070005'
  from sysibm.sysdummy1
union all
select 9, '063000810'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

X75XXX43X
3XXX9XXX6
X14XX7XXX
2XX5XXX8X
14XX3XX92
X3XXX4XX7
XXX6XX27X
8XXX7XXX5
X63XXX81X

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

Lenny

Lenny77 · #42 (**permalink**) 10-27-09, 11:58

Today "Metro", NY page 23:

Code:

Source (line, sudoku_str) as 
(
select 1, '060049081'
  from sysibm.sysdummy1
union all
select 2, '009013050'
  from sysibm.sysdummy1
union all
select 3, '000000900'
  from sysibm.sysdummy1
union all 
select 4, '005120036'
  from sysibm.sysdummy1
union all
select 5, '000000000'
  from sysibm.sysdummy1
union all
select 6, '640035800'
  from sysibm.sysdummy1
union all
select 7, '006000000'
  from sysibm.sysdummy1
union all
select 8, '090360200'
  from sysibm.sysdummy1
union all
select 9, '410850090'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

X6XX49X81
XX9X13X5X
XXXXXX9XX
XX512XX36
XXXXXXXXX
64XX358XX
XX6XXXXXX
X9X36X2XX
41X85XX9X

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

Lenny

Lenny77 · #43 (**permalink**) 10-29-09, 13:44

"Metro", NY 10/29/09 page 19 HARD <-- 1 sec -->

Code:

Source (line, sudoku_str) as 
(
select 1, '000608041'
  from sysibm.sysdummy1
union all
select 2, '010007980'
  from sysibm.sysdummy1
union all
select 3, '004000073'
  from sysibm.sysdummy1
union all 
select 4, '000020000'
  from sysibm.sysdummy1
union all
select 5, '052873190'
  from sysibm.sysdummy1
union all
select 6, '000090000'
  from sysibm.sysdummy1
union all
select 7, '260000400'
  from sysibm.sysdummy1
union all
select 8, '075100030'
  from sysibm.sysdummy1
union all
select 9, '430702000'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

XXX6X8X41
X1XXX798X
XX4XXXX73
XXXX2XXXX
X5287319X
XXXX9XXXX
26XXXX4XX
X751XXX3X
43X7X2XXX

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

Lenny

Lenny77 · #44 (**permalink**) 10-30-09, 12:04

10/30/09 "Metro", NY page 26 HARD --> 4 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '000030500'
  from sysibm.sysdummy1
union all
select 2, '000102460'
  from sysibm.sysdummy1
union all
select 3, '000006102'
  from sysibm.sysdummy1
union all 
select 4, '000091708'
  from sysibm.sysdummy1
union all
select 5, '041000930'
  from sysibm.sysdummy1
union all
select 6, '907460000'
  from sysibm.sysdummy1
union all
select 7, '405300000'
  from sysibm.sysdummy1
union all
select 8, '072605000'
  from sysibm.sysdummy1
union all
select 9, '009080000'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XXXX3X5XX
XXX1X246X
XXXXX61X2
XXXX917X8
X41XXX93X
9X746XXXX
4X53XXXXX
X726X5XXX
XX9X8XXXX

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

10/30/09 "AM", NY page 24 LEVEL-4 --> 25 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '040901000'
  from sysibm.sysdummy1
union all
select 2, '009000205'
  from sysibm.sysdummy1
union all
select 3, '100020790'
  from sysibm.sysdummy1
union all 
select 4, '900200000'
  from sysibm.sysdummy1
union all
select 5, '500300008'
  from sysibm.sysdummy1
union all
select 6, '000007009'
  from sysibm.sysdummy1
union all
select 7, '098060001'
  from sysibm.sysdummy1
union all
select 8, '604000500'
  from sysibm.sysdummy1
union all
select 9, '000402080'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

X4X9X1XXX
XX9XXX2X5
1XXX2X79X
9XX2XXXXX
5XX3XXXX8
XXXXX7XX9
X98X6XXX1
6X4XXX5XX
XXX4X2X8X

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

Lenny Khiger, ADSPA&VP

P.S. I have attached the fresh copy of Solver's code to this message
with today HARD Sudoku

Lenny77 · #45 (**permalink**) 11-02-09, 13:17

11/02/09 "AM", NY very hard (27 start numbers) --> 3 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '004000510'
  from sysibm.sysdummy1
union all
select 2, '320000700'
  from sysibm.sysdummy1
union all
select 3, '000608004'
  from sysibm.sysdummy1
union all 
select 4, '608000000'
  from sysibm.sysdummy1
union all
select 5, '003751900'
  from sysibm.sysdummy1
union all
select 6, '000000205'
  from sysibm.sysdummy1
union all
select 7, '700804000'
  from sysibm.sysdummy1
union all
select 8, '002000031'
  from sysibm.sysdummy1
union all
select 9, '061000400'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

XX4XXX51X
32XXXX7XX
XXX6X8XX4
6X8XXXXXX
XX37519XX
XXXXXX2X5
7XX8X4XXX
XX2XXXX31
X61XXX4XX

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

P.S. Modified code in an attachment

Lenny

Internet Services

Web Development

Digital Marketing

Consumer Tech