Absolute SUDOKU Solver - Page 8

Lenny77 · #**106** (**permalink**) 01-15-10, 12:17

NY Post Sudoku Difficult #1400 << 1 sec >>

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000000000' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '204705308'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '060308010'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '003000500'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '950000036'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '006000700'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '080103050'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '407809601'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000000000' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**107** (**permalink**) 01-19-10, 17:43

"AMNY" - level-4 Sudoku > 5 sec <

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000076040' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '007000100'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '054900870'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '000600002'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '000000010'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '200004000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '072001380'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '001080900'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '060790000' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**108** (**permalink**) 01-22-10, 13:10

01/22/2010 "AMNY" level-4. 23 start numbers, only ! > 7 sec <

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '020090001' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '050060000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '004003008'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '000000087'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '800000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '647000009'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '700500900'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000070060'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '060040020' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**109** (**permalink**) 01-27-10, 18:44

Very Hard in 0 second:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '000060092'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '097020163'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '020007040'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '001902300'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '030800070'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '579040620'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '460090000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**110** (**permalink**) 01-29-10, 13:29

Friday Level-4 Sudoku "AMNY" > 1 sec <

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000000500'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '810400309'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '065020000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '900500000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '704000813'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '000007006'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '000090030'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '601004078'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '008000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**111** (**permalink**) 02-02-10, 14:19

Hard Sudoku solved easy:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '700000009' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '890060000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '010054020'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '000298600'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '007000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '002375000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '050480030'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000010092'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '600000007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**112** (**permalink**) 02-05-10, 18:01

Friday Level-4 Sudoku from "AMNY" <5 sec>:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '030006080' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '000000900'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '700020000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '201070500'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '007000600'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '005060801'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '000740009'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '008000200'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '070500030'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**113** (**permalink**) 02-12-10, 18:16

High level of difficulty Sudoku:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '006109000' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '000030050'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '100000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '910400806'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '080906030'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '403001009'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '000000007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000060080'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000207900'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**114** (**permalink**) 02-19-10, 18:10

Friday Sudoku (HARD) < 1 sec >:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '360002405'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '070050000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '905060300'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '080906100'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '000000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '007405020'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '009080703'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000040080'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '804700096'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**115** (**permalink**) 02-24-10, 17:52

Sudoku as Sudoku. Level 3. > 0 sec <

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000190600'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '800005000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '400080701'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '640000830'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '000809000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '008000016'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '306040002'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000200007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '009038000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**116** (**permalink**) 03-01-10, 13:34

Monday Sudoku <0 sec>:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '309180700'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '001400306'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '020007009'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '000004000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '007000600'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '000700000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '800900070'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '403002100'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000068905'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**117** (**permalink**) 03-04-10, 14:08

Sudoku level-4 < 3 sec >:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000204900'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '000000030'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '100609005'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '056000082'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '000000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '030000170'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '800502007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '060000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '705900800'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny

Lenny77 · #**118** (**permalink**) 03-10-10, 12:10

Quote:

Originally Posted by Lenny77

I want present to you Sudoku Solver, created by me today, which find solution for any level of Sudoku in very short time from 20 to 300 seconds,
depends on difficulty level.

This solution prevents from infinite loop. So if solution exists it'll be found.

In this example I used the very hard sudoku and got solution in 2 minutes.

Sudoku Line

XXX7X29X4
4X1X687XX
XXXXXXXX8
6X7XX142X
XXXXXXXXX
X236XX1X5
1XXXXXXXX
XX827X5X1
7X24X6XXX

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

==> Code in attachment. <==

Thanks everybody (Especially tonkuma) who shown to me drawbacks in the Old Solver.

Leonid Khiger

Please, use the new methods of solution which I had presented to on page 7.

Lenny

Lenny77 · #**119** (**permalink**) 03-12-10, 12:10

Friday Level-4 Sudoku ( 0 sec ):

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '000708000' 
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '600000103'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '040050020'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '005021070'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '700000009'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '000480500'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '030000090'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '209060007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000802000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Quote:

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

Lenny (page 7)

Lenny77 · #**120** (**permalink**) 03-19-10, 12:16

Friday Level-4 Sudoku < 15 sec >:

Code:

select max(sd_id) from final table
(insert into Sd_Source  
select ifnull(max(sd_id), 0) + 1, 1, '800000000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())       
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 2, '600319000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 3, '000500090'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all 
select ifnull(max(sd_id), 0) + 1, 4, '302000800'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 5, '090205070'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 6, '008000004'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 7, '064003000'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 8, '000920007'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
union all
select ifnull(max(sd_id), 0) + 1, 9, '000000005'
     , ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
  from Sd_Source 
);

Result:

Quote:

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

Lenny

Internet Services

Web Development

Digital Marketing

Consumer Tech