View Single Post
  #70 (permalink)  
Old 12-01-09, 14:15
Lenny77 Lenny77 is offline
Registered User
 
Join Date: Jul 2009
Location: NY
Posts: 886
Wink ZERO seconds for 27 start numbers (1/3 of 9 x 9)

12/01/09 "AM" NY, page 27 --> 0 sec <--

Code:
Source (line, sudoku_str) as 
(
select 1, '900020006'
  from sysibm.sysdummy1
union all
select 2, '020001090'
  from sysibm.sysdummy1
union all
select 3, '010900400'
  from sysibm.sysdummy1
union all 
select 4, '095002000'
  from sysibm.sysdummy1
union all
select 5, '000507020'
  from sysibm.sysdummy1
union all
select 6, '000300810'
  from sysibm.sysdummy1
union all
select 7, '008004050'
  from sysibm.sysdummy1
union all
select 8, '040100030'
  from sysibm.sysdummy1
union all
select 9, '600080009'
  from sysibm.sysdummy1
)
Quote:
Line 1: | 9 | 3 | 7 | 4 | 2 | 5 | 1 | 8 | 6 |
Line 2: | 8 | 2 | 4 | 6 | 7 | 1 | 5 | 9 | 3 |
Line 3: | 5 | 1 | 6 | 9 | 3 | 8 | 4 | 7 | 2 |
Line 4: | 4 | 9 | 5 | 8 | 1 | 2 | 3 | 6 | 7 |
Line 5: | 1 | 8 | 3 | 5 | 6 | 7 | 9 | 2 | 4 |
Line 6: | 7 | 6 | 2 | 3 | 4 | 9 | 8 | 1 | 5 |
Line 7: | 3 | 7 | 8 | 2 | 9 | 4 | 6 | 5 | 1 |
Line 8: | 2 | 4 | 9 | 1 | 5 | 6 | 7 | 3 | 8 |
Line 9: | 6 | 5 | 1 | 7 | 8 | 3 | 2 | 4 | 9 |
Lenny
Reply With Quote