sum(case when (DATEPART(quarter, Document.FinishDate) = 1) then CONVERT(float,DocumentExpenseItem.Amount) else 0 end)as st,
sum(case when (DATEPART(quarter, Document.FinishDate) = 2) then CONVERT(float, DocumentExpenseItem.Amount) else 0 end)as nd ,
sum(case when (DATEPART(quarter,Document.FinishDate) = 3) then CONVERT(float, DocumentExpenseItem.Amount) else 0 end)as rd ,
sum(case when (DATEPART(quarter,Document.FinishDate) = 4) then CONVERT(float, DocumentExpenseItem.Amount) else 0 end)as th
转载于:https://www.cnblogs.com/AllenYang/archive/2012/02/03/2336914.html