我想在SQL Server 2008中使用pivot将行设置为列，但列具有字符串值，因此无法对其应用聚合函数

CREATE PROCEDURE DynamicPivot
AS
BEGIN
    DECLARE @columns NVARCHAR(MAX), @query NVARCHAR(MAX);

    -- 获取所有不同的列值
    SELECT @columns = COALESCE(@columns + ', ', '') + QUOTENAME(ColumnValue)
    FROM (
        SELECT DISTINCT ColumnValue
        FROM YourTable
    ) AS ColumnValues;

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

    -- 执行动态SQL查询
    EXEC sp_executesql @query;
END