34,838
社区成员




SELECT VA.A / VB.A AS TB ,
VA.A / VC.A AS HB ,
VA.Y ,
VA.M ,
VA.dept
FROM dbo.V_Amount VA
LEFT JOIN dbo.V_Amount VB ON VA.dept = VB.dept
AND VA.M = VB.M
AND VB.Y = VA.Y - 1
LEFT JOIN dbo.V_Amount VC ON VA.dept = VC.dept
AND VA.Y = VC.Y
AND VC.M = VA.M - 1
WHERE VA.Y = '2012'
SELECT SUM(amount) AS A, Y, M, dept
FROM (SELECT id, date, dept, amount, YEAR(date) AS Y, MONTH(date) AS M, DATENAME(week, date) AS W
FROM dbo.Amount) AS A
GROUP BY Y, M, dept