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.
- Size of matrix for which we want to create all the possibilities.
- Table Value Parameter which is used to pass valid user entries. Below is structure of TVP.
Suppose, we have 4X4 matrix with below values for which I want to create all valid possibilities
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
Select * From MetrixPosibilities_4X4
Here, we have 2 valid possibilities created as below in table dbo.MetrixPosibilities_4X4.
Below are the scripts to download.