sql 行转列 四季度求和
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