Sample Script
Use the TSQL Script given below to generate the source table and fill them with sample data.
IF OBJECT_ID('TC63','U') IS NOT NULL BEGIN
DROP TABLE TC63
END
GO
CREATE TABLE TC63(
SudokuNo INT,
Row INT,
Col INT,
Data INT
)
GO
INSERT INTO TC63(SudokuNo,Row,Col,Data)
SELECT 1,2,1,9 UNION ALL
SELECT 1,3,1,2 UNION ALL
SELECT 1,4,1,5 UNION ALL
SELECT 1,6,1,6 UNION ALL
SELECT 1,8,1,3 UNION ALL
SELECT 1,9,1,8 UNION ALL
SELECT 1,5,2,1 UNION ALL
SELECT 1,6,2,3 UNION ALL
SELECT 1,8,2,2 UNION ALL
SELECT 1,4,3,2 UNION ALL
SELECT 1,8,3,4 UNION ALL
SELECT 1,9,3,6 UNION ALL
SELECT 1,2,4,3 UNION ALL
SELECT 1,5,4,8 UNION ALL
SELECT 1,6,4,1 UNION ALL
SELECT 1,7,4,2 UNION ALL
SELECT 1,3,5,8 UNION ALL
SELECT 1,5,5,9 UNION ALL
SELECT 1,7,5,4 UNION ALL
SELECT 1,3,6,7 UNION ALL
SELECT 1,4,6,4 UNION ALL
SELECT 1,5,6,5 UNION ALL
SELECT 1,8,6,6 UNION ALL
SELECT 1,1,7,3 UNION ALL
SELECT 1,2,7,5 UNION ALL
SELECT 1,6,7,8 UNION ALL
SELECT 1,2,8,4 UNION ALL
SELECT 1,4,8,1 UNION ALL
SELECT 1,5,8,6 UNION ALL
SELECT 1,1,9,8 UNION ALL
SELECT 1,2,9,2 UNION ALL
SELECT 1,4,9,7 UNION ALL
SELECT 1,6,9,4 UNION ALL
SELECT 1,7,9,5 UNION ALL
SELECT 1,8,9,1
SELECT * FROM TC63