34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE ss
as
begin
declare @count [nvarchar] (20)
declare cur_custer cursor
for
select [保单号] from ss_temp
print '开始执行'
open cur_custer
fetch next from cur_custer into @count
while(@@fetch_status=0) --循环开始
begin
if EXISTS(select 业务实收表.保单号 from 业务实收表 join ss_temp on 业务实收表.保单号=ss_temp.保单号 where 业务实收表.保单号=@count)
begin
Exec('update 业务实收表 set 财务结清日期=aa.财务结清日期,业务实收表.电子收据保费=业务实收表.电子收据保费+aa.电子收据保费 from ss_temp aa where aa.保单号=业务实收表.保单号 and aa.保单号='+@count)
print '更新'
end
else
begin
Exec('insert 业务实收表 select * from ss_temp where ss_temp.保单号='+@count)
print '插入'
print 'test'
end
fetch next from cur_custer into @count
end
print '结束'
close cur_custer --关闭游标
deallocate cur_custer--释放资源
end
GO
update bb
set 财务结清日期=aa.财务结清日期,bb.电子收据保费=bb.电子收据保费+aa.电子收据保费
from ss_temp aa
right join 业务实收表 bb
on aa.保单号=bb.保单号
where exists(select 1 from 业务实收表 where 保单号=aa.保单号 )
update bb
set 财务结清日期=aa.财务结清日期,bb.电子收据保费=bb.电子收据保费+aa.电子收据保费
from ss_temp aa
right join 业务实收表 bb
on aa.保单号=bb.保单号
and exists(select 1 from 业务实收表 where 保单号=aa.保单号 )