>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 >