TFS统计编码行数语句

SELECT TeamProjectProjectNodeName 项目名称        ,checkedinbyname 开发人员        ,SUM([LinesAdded]) AS 代码添加行数        ,SUM([LinesModified]) AS 代码修改行数        ,SUM([LinesAdded]+[LinesModified]) AS 代码变动行数        ,CONVERT(VARCHAR(10), MIN(DateTime),120) AS 开始时间        ,CONVERT(VARCHAR(10),MAX(DateTime),120) AS 结束时间    FROM [Tfs_Warehouse].[dbo].[CodeChurnView] WHERE  (LinesDeleted <>0 OR LinesModified<>0) AND NetLinesAdded>=0  GROUP BY TeamProjectProjectNodeName, checkedinbyname   ORDER BY 项目名称, 代码变动行数 DESC