使用SQL Server将逗号分隔的文本转换为多列结果

CREATE PROCEDURE SplitTextToColumns
    @Text VARCHAR(MAX)
AS
BEGIN
    DECLARE @Delimiter CHAR(1) = ','
    DECLARE @TempTable TABLE (Value VARCHAR(MAX))

    WHILE CHARINDEX(@Delimiter, @Text) > 0
    BEGIN
        INSERT INTO @TempTable (Value)
        SELECT
            Value = LTRIM(RTRIM(SUBSTRING(@Text, 1, CHARINDEX(@Delimiter, @Text) - 1)))

        SET @Text = SUBSTRING(@Text, CHARINDEX(@Delimiter, @Text) + 1, LEN(@Text))
    END

    INSERT INTO @TempTable (Value)
    SELECT Value = LTRIM(RTRIM(@Text))

    SELECT *
    FROM
        (SELECT
            Value,
            ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNumber
        FROM @TempTable) AS T
    PIVOT
    (
        MAX(Value)
        FOR RowNumber IN ([1], [2], [3], [4], [5]) -- 根据实际情况设置列数
    ) AS P
END

EXEC SplitTextToColumns 'Value1,Value2,Value3,Value4,Value5'