Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Absolute SUDOKU Solver

Reply
Page 8 of 15 « First 67 8 910 Last »
 
LinkBack Thread Tools Search this Thread Display Modes
  #106 (permalink)  
Old 01-15-10, 11:17
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Post Post Sudoku
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
Reply With Quote
  #107 (permalink)  
Old 01-19-10, 16:43
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Smile "AMNY" - level-4 Sudoku
"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
Reply With Quote
  #108 (permalink)  
Old 01-22-10, 12:10
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Exclamation "AMNY" level-4. 23 start numbers, only !
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
Reply With Quote
  #109 (permalink)  
Old 01-27-10, 17:44
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Cool Very Hard Sudoku
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
Reply With Quote
  #110 (permalink)  
Old 01-29-10, 12:29
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Talking Friday Level-4 Sudoku
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
Reply With Quote
  #111 (permalink)  
Old 02-02-10, 13:19
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Thumbs up Not exist the Hard Sudokus to us !
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
Reply With Quote
  #112 (permalink)  
Old 02-05-10, 17:01
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Cool Friday Level-4 Sudoku from "AMNY"
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
Reply With Quote
  #113 (permalink)  
Old 02-12-10, 17:16
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Wink High level Sudoku
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
Reply With Quote
  #114 (permalink)  
Old 02-19-10, 17:10
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Cool Friday Sudoku (HARD)
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
Reply With Quote
  #115 (permalink)  
Old 02-24-10, 16:52
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Talking Level 3 Sudoku
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
Reply With Quote
  #116 (permalink)  
Old 03-01-10, 12:34
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Smile Monday Sudoku
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
Reply With Quote
  #117 (permalink)  
Old 03-04-10, 13:08
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Talking Sudoku level-4
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
Reply With Quote
  #118 (permalink)  
Old 03-10-10, 11:10
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Exclamation Solution on page 7
Quote:
Originally Posted by Lenny77 View Post
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
Reply With Quote
  #119 (permalink)  
Old 03-12-10, 11:10
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Smile Friday Level-4 Sudoku
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)
Reply With Quote
  #120 (permalink)  
Old 03-19-10, 11:16
Lenny77 Lenny77 is offline
Registered User
  
Join Date: Jul 2009
Location: NY
Posts: 886
Cool Friday Level-4 Sudoku
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
Reply With Quote
Reply
Page 8 of 15 « First 67 8 910 Last »

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.