---------执行前最好能做下数据备份
------到sql查询分析器中选择赢通帐套数据库名称执行下面全部语句。（一次执行）

--总部重整会员余额;
declare @branch_tmp varchar(100),@vip_no varchar(50),@save_amt numeric(18,2)
declare cur_vip cursor for
select vip_no from t_vip_info
open cur_vip
fetch cur_vip into @vip_no
while @@fetch_status =0
begin
--重算存储余额;
delete t_vip_money where vip_no = @vip_no and money_type ='4' and branch_no ='*'
select @save_amt = IsNull(sum(save_amt),0.00) from t_vip_flow where vip_no =@vip_no
if @save_amt <>0.00
insert t_vip_money(vip_no, branch_no, money_type, vip_sort, value_amt, use_amt, memo)
values (@vip_no,'*','4',1,@save_amt,0.00,'重整数据')

--重算赠送额;
delete t_vip_money where vip_no = @vip_no and money_type ='2' and branch_no ='*'
select @save_amt = IsNull(sum(give_amt),0.00) from t_vip_flow where vip_no =@vip_no
if @save_amt <>0.00
insert t_vip_money(vip_no, branch_no, money_type, vip_sort, value_amt, use_amt, memo)
values (@vip_no,'*','2',1,@save_amt,0.00,'重整数据')

--重算积分;
delete t_vip_money where vip_no = @vip_no and money_type ='5' and branch_no ='*'
select @save_amt = IsNull(sum(integral),0.00) from t_vip_flow where vip_no =@vip_no
if @save_amt>0.00
insert t_vip_money(vip_no, branch_no, money_type, vip_sort, value_amt, use_amt, memo)
values (@vip_no,'*','5',1,@save_amt,0.00,'重整数据')

--重算返利
delete t_vip_money where vip_no = @vip_no and money_type ='1' and branch_no ='*'
select @save_amt = IsNull(sum(ret_amt),0.00) from t_vip_flow where vip_no =@vip_no
if @save_amt>0.00
insert t_vip_money(vip_no, branch_no, money_type, vip_sort, value_amt, use_amt, memo)
values (@vip_no,'*','1',1,@save_amt,0.00,'重整数据')

--重算零钱余额
delete t_vip_money where vip_no = @vip_no and money_type ='3' and branch_no ='*'
select @save_amt = IsNull(sum(zero_amt),0.00) from t_vip_flow where vip_no =@vip_no
if @save_amt>0.00
insert t_vip_money(vip_no, branch_no, money_type, vip_sort, value_amt, use_amt, memo)
values (@vip_no,'*','3',1,@save_amt,0.00,'重整数据')

fetch cur_vip into @vip_no
end
deallocate cur_vip