在SQL Server中从csv字符串序列生成二进制矩阵(2012)？

CREATE PROCEDURE GenerateBinaryMatrix
    @csvString NVARCHAR(MAX)
AS
BEGIN
    -- 创建临时表来存储结果
    CREATE TABLE #BinaryMatrix (
        RowIndex INT,
        ColumnIndex INT,
        Value BIT
    )

    -- 使用递归CTE将csv字符串拆分为行和列
    ;WITH Rows AS (
        SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowIndex,
               ROW_VALUE
        FROM STRING_SPLIT(@csvString, CHAR(10))
    ),
    Columns AS (
        SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS ColumnIndex,
               VALUE
        FROM STRING_SPLIT((SELECT ROW_VALUE FROM Rows WHERE RowIndex = 1), ',')
    ),
    RecursiveCTE AS (
        SELECT RowIndex, ColumnIndex, CAST(VALUE AS BIT) AS Value
        FROM Rows
        CROSS JOIN Columns
        WHERE RowIndex = 1

        UNION ALL

        SELECT r.RowIndex, c.ColumnIndex, CAST(s.VALUE AS BIT) AS Value
        FROM RecursiveCTE r
        JOIN Rows s ON r.RowIndex + 1 = s.RowIndex
        CROSS JOIN Columns c
        WHERE c.ColumnIndex = r.ColumnIndex + 1
    )
    -- 将结果插入临时表
    INSERT INTO #BinaryMatrix (RowIndex, ColumnIndex, Value)
    SELECT RowIndex, ColumnIndex, Value
    FROM RecursiveCTE

    -- 查询结果
    SELECT *
    FROM #BinaryMatrix

    -- 删除临时表
    DROP TABLE #BinaryMatrix
END

EXEC GenerateBinaryMatrix @csvString = '1,0,1
0,1,0
1,0,1'