select sum(f_money) f_money,f_member as f_accounts,max(f_majordomo) f_majordomo from (
select sum(case when f_typ<>'b_et' and f_typ<>'b_vd' and f_typ<>'b_dz' then f_mo5 else 0 end) + sum(case when f_typ='b_vd'then f_PublicPoint else 0 end) as f_money,f_member,max(f_majordomo) as f_majordomo
from t_oldbill with(nolock) where f_del=0 and f_date between '2016/11/2 0:00:00'and '2016/11/2 23:59:59' group by f_member
union all
select sum(f_mo5) +0 as f_money,f_member,max(f_majordomo) f_majordomo from t_oldbill_gg a
where f_date between '2016/11/2 0:00:00'and '2016/11/2 23:59:59' and f_del=0 and isnull(f_mresult,0)<>0 and f_member is not null
group by f_member
) as temp where temp.f_money > 0 group by temp.f_member ;
另一个：
select '历史银行存款' = (select isnull(sum(f_money),0) from
t_OldDeltaRecords with(nolock) where f_Audit > 0 and isnull(f_del,0) =0 and f_accounts = 'F6023' and f_time between '2015-11-01' and '2016-11-04') +
(select isnull(sum(f_money),0) from t_StatisticsDeltaRecords with(nolock) where f_accounts = 'F6023' and f_date between convert(varchar(7),'2015-11-01',120) and convert(varchar(7),
'2016-11-04',120) ),
'历史支付宝存款' = (select isnull(sum(f_money),0) from t_OldDeltaAlipay with(nolock) where isnull(f_del,0) =0 and f_Audit>0 and f_accounts = 'F6023' and f_time between '2015-11-01' and
'2016-11-04' ) + (select isnull(sum(f_money),0) from t_OldDeltaOnline with(nolock) where f_State>0 and f_payType =2 and isnull(f_del,0) =0 and f_accounts = 'F6023' and f_time between
'2015-11-01' and '2016-11-04') + (select isnull(sum(f_money),0) from t_StatisticsDeltaOnline with(nolock) where f_type =2 and f_accounts = 'F6023' and f_date between convert(varchar(7),
'2015-11-01',120) and convert(varchar(7),'2016-11-04',120)) + (select isnull(sum(f_money),0) from t_StatisticsDeltaAlipay with(nolock) where f_accounts = 'F6023' and f_date between
convert(varchar(7),'2015-11-01',120) and convert(varchar(7),'2016-11-04',120)),
'历史微信存款' = (select isnull(sum(f_money),0) from t_OldDeltaWeChat with(nolock) where isnull(f_del,0) =0 and f_Audit>0 and f_accounts = 'F6023' and f_time between '2015-11-01' and '2016-11-04' )+
(select isnull(sum(f_money),0) from t_OldDeltaOnline with(nolock) where f_State>0 and f_payType =1 and isnull(f_del,0) =0 and f_accounts = 'F6023' and f_time between '2015-11-01' and '2016-11-04') +
(select isnull(sum(f_money),0) from t_StatisticsDeltaOnline with(nolock) where f_type =1 and f_accounts = 'F6023' and f_date between convert(varchar(7),'2015-11-01',120) and convert(varchar(7),'2016-11-04',120)) +
(select isnull(sum(f_money),0) from t_StatisticsDeltaWeChat with(nolock) where f_accounts = 'F6023' and f_date between convert(varchar(7),'2015-11-01',120) and convert(varchar(7),'2016-11-04',120)),
'历史在线存款' = (select isnull(sum(f_money),0) from t_OldDeltaOnline with(nolock) where f_State>0 and
f_payType <> 1 and f_payType <> 2
and isnull(f_del,0) =0 and f_accounts = 'F6023' and f_time between '2015-11-01' and '2016-11-04')+ (select isnull(sum(f_money),0) from t_StatisticsDeltaOnline with(nolock) where f_type <> 1 and f_type <> 2
and f_accounts = 'F6023' and f_date between convert(varchar(7),'2015-11-01',120) and convert(varchar(7),'2016-11-04',120)) ;
我的天，这哪里看的下去哟，不可以用存储过程么