条件SQL

[QiQi_yun]

select a.BlockID as '卡号',
sum(a.SavingTotal)as '期初累计充值',
sum(a.ProductMoney+a.ServerMoney) as '本次充值',
sum (a.SavingTotal+a.ProductMoney+a.ServerMoney) as '充值合计',
sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )as '本日消费',
sum(case when datediff(month,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end)as '本月累计消费',
sum(a.AlreadlyConsume)as '已消费金额',
sum(a.[Money]) as '卡内余额' 
from tb_ConsumeCar as a 
,tb_ClientConsume as b
where a.BlockID=b.BlockID
and ( b.SortType =0 or b.SortType =1 or b.SortType =2)
group by a.BlockID

以上SQL是正确可运行
但是在where后面还要加上以下条件:(意思是'本日消费'大于0才显示)

sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )as '本日消费',

谢谢各位高手,我努力学习中...
P:BS一下自己,为这条SQL语句,我问了二次了....不好意思!!

[中国风]

加上
having sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )>0

[让你望见影子的墙]

问题解决了就行，谁都有这么一个过程，不用bs自己

[QiQi_yun]

select a.BlockID as '卡号',
sum(a.SavingTotal)as '期初累计充值',
sum(a.ProductMoney+a.ServerMoney) as '本次充值',
sum (a.SavingTotal+a.ProductMoney+a.ServerMoney) as '充值合计',
sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )as '本日消费',
sum(case when datediff(month,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end)as '本月累计消费',
sum(a.AlreadlyConsume)as '已消费金额',
sum(a.[Money]) as '卡内余额' 
from tb_ConsumeCar as a 
,tb_ClientConsume as b
where a.BlockID=b.BlockID
and ( b.SortType =0 or b.SortType =1 or b.SortType =2)
group by a.BlockID
having (sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )>0)

呵呵,我刚刚想到的是这个
不过也感谢二位!

[utpcb]

select*from 

(select a.BlockID as '卡号',
sum(a.SavingTotal)as '期初累计充值',
sum(a.ProductMoney+a.ServerMoney) as '本次充值',
sum (a.SavingTotal+a.ProductMoney+a.ServerMoney) as '充值合计',
sum(case when datediff(day,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end )as '本日消费',
sum(case when datediff(month,b.ConsumeDate,getdate())=0 then (b.ProductMoney+b.ServiceItemMoney+b.ServiceCardMoney) else 0 end)as '本月累计消费',
sum(a.AlreadlyConsume)as '已消费金额',
sum(a.[Money]) as '卡内余额' 
from tb_ConsumeCar as a 
,tb_ClientConsume as b
where a.BlockID=b.BlockID
and ( b.SortType =0 or b.SortType =1 or b.SortType =2)
group by a.BlockID
) t
where 本日消费>0

[QiQi_yun]

呜呜不好意思4楼,怪我结贴太积极了,没有分给你了!!

对不起!!