>>SELECT Ministerie, Departement, KSC, Kostensoort, >> Year, >> ISNULL(QPivot.[1],0.00) + >> ISNULL(QPivot.[2],0.00) + >> ISNULL(QPivot.[3],0.00) + >> ISNULL(QPivot.[4],0.00) AS Total, >> >> ISNULL(QPivot.[1],0.00) AS Q1, >> ISNULL(QPivot.[2],0.00) AS Q2, >> ISNULL(QPivot.[3],0.00) AS Q3, >> ISNULL(QPivot.[4],0.00) AS Q4 >> >>FROM (SELECT DepGroups.dgName AS Ministerie, >> Departments.deName AS Departement, >> GLSub.gsAccount AS KSC, >> GLSub.gsDescr AS Kostensoort, >> DATEPART(YEAR,Runs.ruStartDat) AS Year, >> DATEPART(Quarter, Runs.ruStartDat) AS Quarter, >> SUM(itAmount) AS itAmount >> >> FROM PayEmps >> >> JOIN Departments >> ON Departments.DeKey = PayEmps.paDeKey >> JOIN DepGroups >> ON Departments.deDgKey = DepGroups.dgKey >> JOIN Runs >> ON Runs.ruKey = PayEmps.paRuKey >> >> LEFT JOIN HistItems Items >> ON Items.itRuKey = Runs.ruKey >> AND Items.itEmKey = PayEmps.paEmKey >> >> LEFT JOIN GLSub >> ON Items.itGsKey = GLSub.gsKey >> >> WHERE PayEmps.delFlag = 0 >> AND Runs.DelFlag = 0 >> AND Runs.ruConcept = 0 >> AND Runs.ruStatus = 5 >> AND DATEPART(YEAR,Runs.ruStartDat) = ?pnYear >> AND Items.DelFlag = 0 >> AND GsAccount = '4101' >> AND Runs.ruYear = 2015 >> >> GROUP BY DepGroups.dgName, Departments.deName, >> GLSub.gsAccount, GLSub.gsDescr, >> DATEPART(YEAR,Runs.ruStartDat), >> DATEPART(QUARTER,Runs.ruStartDat)) AS QuarterlyData >> >> PIVOT(SUM([itAmount]) >> FOR QUARTER IN ([1],[2],[3],[4])) AS QPivot >> >> ORDER BY Ministerie, Departement, KSC >>