您可以使用ROW_NUMBER()来取得1到10的数字清单。
然后，您可以将MIN()或MAX()用于nvarchar列。

SELECT [IdTask]
    , [Name]
    , [1]
    , [2]
    , [3]
    , [4]
    , [5]
    , [6]
    , [7]
    , [8]
    , [9]
    , [10]
FROM
(
SELECT [IdTask]
    , ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [CreatedAt]) AS RowNum
    , [Name]
    , [Fr]
FROM [dbo].[vRapport]
) AS SourceTable
PIVOT
(
    MIN(Fr)
    FOR RowNum IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10])
) AS PivotTable;

如果您希望从您提供的查询开始，您可以使用CTE：

WITH CTE AS (
SELECT [IdTask]
      ,[Name]
      ,[LogType]
      ,[Fr]
      ,[Input]
      ,[CreatedAt]
  FROM [dbo].[vRapport]
)
SELECT [IdTask]
    , [Name]
    , [1]
    , [2]
    , [3]
    , [4]
    , [5]
    , [6]
    , [7]
    , [8]
    , [9]
    , [10]
FROM
(
SELECT [IdTask]
    , ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [CreatedAt]) AS RowNum
    , [Name]
    , [Fr]
FROM CTE
) AS SourceTable
PIVOT
(
    MIN(Fr)
    FOR RowNum IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10])
) AS PivotTable;

有关ROW_NUMBER()的更多信息，请访问：https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16