我有一个视图.create view dbo.zwsh1
as
select zongzhangkemu,jizhangfuhao, sum(jiefangjine) as jie,sum(daifangjine)as dai from zhangwupingzheng
group by zongzhangkemu,jizhangfuhao 我想判断根据fuhao(bit型,当为0时,jiefangjine有值,否则,daifangjine有值)
想用这个视图实现汇总两个值字段的效果,但是不太如意,
哪位朋友帮我想想办法?
as
select zongzhangkemu,jizhangfuhao, sum(jiefangjine) as jie,sum(daifangjine)as dai from zhangwupingzheng
group by zongzhangkemu,jizhangfuhao 我想判断根据fuhao(bit型,当为0时,jiefangjine有值,否则,daifangjine有值)
想用这个视图实现汇总两个值字段的效果,但是不太如意,
哪位朋友帮我想想办法?
sum(case when fuhao=0 then jiefangjine else 0 end)
as
select zongzhangkemu,jizhangfuhao,
sum(case when fuhao=0 then jiefangjine else daifangjine end)
from zhangwupingzheng
group by zongzhangkemu,jizhangfuhao
create view dbo.zwsh1
as
select zongzhangkemu,jizhangfuhao,
sum(iif(fuhao=0, jiefangjine , daifangjine))
from zhangwupingzheng
group by zongzhangkemu,jizhangfuhao