sql-server-2008 - 如何在动态枢轴内舍入数字？

Question

所以我有这个:

DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
DECLARE @ColumnName AS NVARCHAR(MAX)


--Get distinct values of the PIVOT Column 
SELECT @ColumnName= ISNULL(@ColumnName + ',','') 
       + QUOTENAME(period)
FROM (SELECT DISTINCT period FROM atbv_Accounting_Transactions WHERE lAccountNO LIKE '6%' AND Period LIKE '2017%') AS Periods

SET @DynamicPivotQuery = 
    N'SELECT lAccountNo, ' + @ColumnName + '
    FROM (SELECT
    lAccountNo, period, SUM(Amount) As Total
    FROM atbv_Accounting_Transactions 
    WHERE lAccountNO LIKE ''6%'' AND Period LIKE ''2017%''
    GROUP BY lAccountNo, period
    ) AS T
    PIVOT(SUM(TOTAL) 
          FOR period IN (' + @ColumnName + ')) AS PVTTable'

--Execute the Dynamic Pivot Query
 EXEC sp_executesql @DynamicPivotQuery

它返回给我:

我如何删除 select 本身的小数位。我无法编辑表中的列并减少小数位。因此我需要编辑此查询以返回不带小数的值。

谢谢!

Answer 1

应该只将 SUM(Amount) 更改为 cast(SUM(Amount) as int) 或者 floor(SUM(Amount))它会成功的。