如何基于返回数据透视表的SQL Server存储过程创建模型和视图？

CREATE PROCEDURE GetPivotData
    @ColumnName NVARCHAR(50),
    @TableName NVARCHAR(50)
AS
BEGIN
    -- 存储过程逻辑
END

CREATE PROCEDURE GetPivotData
    @ColumnName NVARCHAR(50),
    @TableName NVARCHAR(50)
AS
BEGIN
    -- 创建临时表
    CREATE TABLE #TempTable
    (
        ColumnName NVARCHAR(50),
        ColumnValue NVARCHAR(50)
    )

    -- 插入需要透视的数据
    INSERT INTO #TempTable
    SELECT @ColumnName, ColumnName
    FROM @TableName

    -- 生成透视表
    DECLARE @PivotColumns NVARCHAR(MAX)
    SELECT @PivotColumns = COALESCE(@PivotColumns + ', ', '') + QUOTENAME(ColumnName)
    FROM #TempTable

    DECLARE @DynamicPivotQuery NVARCHAR(MAX)
    SET @DynamicPivotQuery = N'
        SELECT *
        FROM #TempTable
        PIVOT
        (
            MAX(ColumnValue)
            FOR ColumnName IN (' + @PivotColumns + ')
        ) AS PivotTable'

    EXEC sp_executesql @DynamicPivotQuery

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

CREATE MODEL PivotModel
AS
SELECT *
FROM GetPivotData('ColumnName', 'TableName')

CREATE VIEW PivotView
AS
SELECT *
FROM PivotModel