lyfz_repos/经典版源码/document/数据库维护脚本/会员积分翻倍解决.sql

--merberreg修改除dindanid=订单号的其他所有记录的money=money/10,且日期小于等于2015-01-18的
use [db]
go
update [memberreg] set [money]=[money]*10 where dindanid not in(select id from [dindan]) and [date] = '2015-05-12'
go

--merberreg修改所有记录的money=money/10,且日期小于等于2015-01-18的
use [db]
go
update [membermanage] set [money]=convert(float,[money],10)*10 where [date] = '2015-05-12' 
and memberno not in(
SELECT memberno  FROM [memberreg] 
where exists(select id from [dindan] where [memberreg].[dindanid] = [dindan].[id])
)
go