公司要把一张组成表的数据汇总起来并与主明细表并列显示
组成表
Cost_ID | Cost_type | Money |
1 | 水费 | ** |
1 | 污水费 | ** |
2 | 水费 | *** |
exec PROCEDURE...
GO
CREATE procedure ...
...
AS
Begin
select [...],...
from [tab...] [tab..a]
join (
select [Cost_ID]
,SUM(CASE WHEN [Cost_Type] <> '水费' THEN isnull([money],0) ELSE 0.0 END) AS [...]
,SUM(CASE [Cost_Type] WHEN '污水费' THEN isnull([money],0) ELSE 0.0 END) AS [...]
,SUM(CASE [Cost_Type] WHEN '违约金' THEN isnull([money],0) ELSE 0.0 END) AS [...]
from [Cost] main
where 1=1
group by [Cost_ID]
) [tab..b] on [tab..a].[Cost_ID]= [tab..b].[Cost_ID]
END