如何对sql server上的一列执行透视，但已重命名为dynamic列

DECLARE @columns NVARCHAR(MAX);
DECLARE @query NVARCHAR(MAX);

-- 获取所有需要动态重命名的列
SELECT @columns = COALESCE(@columns + ', ', '') + QUOTENAME(NewColumnName)
FROM (SELECT DISTINCT NewColumnName FROM YourTable) AS ColumnNames;

-- 构建动态SQL查询语句
SET @query = N'
SELECT *
FROM
(
    SELECT OriginalColumnName, NewColumnName, ColumnValue
    FROM YourTable
) AS SourceTable
PIVOT
(
    MAX(ColumnValue)
    FOR OriginalColumnName IN (' + @columns + ')
) AS PivotTable;';

-- 执行动态SQL查询
EXEC(@query);