Saturday, February 7, 2015

Write T-SQL code to take m valid values from User and provide all valid Sudoku possibilities for nXn matrix

Continue to my last post “Write T-SQL code to provide all valid Sudoku possibilities for nXn matrix.

I modified the procedure sc.cp_Create_MetrixPosibilities_nXn which also take m valid values from User for matrix and create table dbo.MetrixPosibilities_nXn with all valid Sudoku possibilities.

Below are parameters for the procedure sc.cp_Create_MetrixPosibilities_nXn.

  1. @p_MatrixSize
    1. Size of matrix for which we want to create all the possibilities.
  2. @v_PositionMatrixValue
    1. Table Value Parameter which is used to pass valid user entries. Below is structure of TVP.
      1. PositionX
      2. PositionY
      3. Value

Suppose, we have 4X4 matrix with below values for which I want to create all valid possibilities

4X4 - Copy

We can execute procedure as below.

Declare @v_PositionMatrixValue as PositionMatrixValue

Insert into @v_PositionMatrixValue values(1,1,1)
Insert into @v_PositionMatrixValue values(2,2,2)
Insert into @v_PositionMatrixValue values(3,3,3)
Insert into @v_PositionMatrixValue values(4,4,4)

EXEC sc.cp_Create_MetrixPosibilities_nXn 4, @v_PositionMatrixValue, 0
Go

Select * From MetrixPosibilities_4X4

Here, we have 2 valid possibilities created as below in table dbo.MetrixPosibilities_4X4.

image

Below are the scripts to download.

1. sc.cp_Create_MetrixPosibilities_nXn_V2.sql

Tuesday, February 3, 2015

Write T-SQL code to provide all valid Sudoku possibilities for nXn matrix.

This post specially dedicated to Anjana Ramamoorthy from Microsoft.

Below is the procedure sc.cp_Create_MetrixPosibilities_nXn which will take matrix size as parameter and create the table dbo.MetrixPosibilities_nXn with all valid Sudoku possibilities.

Below are parameters for the procedure sc.cp_Create_MetrixPosibilities_nXn.

  1. @p_MatrixSize
    1. Size of matrix for which we want to create all the possibilities.

Suppose, we have 3X3 matrix for which I want to create all valid possibilities then we can execute procedure as below.

EXEC sc.cp_Create_MetrixPosibilities_nXn 3
Go
Select count(1) From dbo.MetrixPosibilities_3X3
--> 12

Here, we have 12 valid possibilities created as below in table dbo.MetrixPosibilities_3X3.

image

Below are the scripts to download.

1. sc.cp_Create_MetrixPosibilities_nXn.sql

Please keep watching for the second post.

Write T-SQL code to take m valid values from User and provide all valid Sudoku possibilities for nXn matrix