CREATE VIEW dbo.VIEW_test
AS
SELECT DISTINCT '0' + 部门 AS p1, 部门 , '' as 人员名, NULL as 金额 FROM test
UNION
SELECT '0' + 部门 + '1' AS p1, 部门, 人员名, 金额
FROM test
UNION
SELECT '0' + 部门 + '2' AS p1, '小计' as 部门 , '' as 人员名, SUM(金额) as 金额
FROM test
GROUP BY 部门
UNION
SELECT '1' + '总计' AS p1, '总计' as 部门 , '' as 人员名 , SUM(金额) as 金额
FROM test
SELECT DISTINCT '0'+部门 AS p1, 部门, '', NULL FROM test
UNION
SELECT '0'+部门 + '1' AS p1, 部门, 人员名, 金额 FROM test
UNION
SELECT '0'+部门 + '2' AS p1, '小计', '', SUM(金额) FROM test GROUP BY 部门
UNION
SELECT '1'+'总计' AS p1, '总计', '', SUM(金额) FROM test
ORDER BY p1