Update InsurancePlan Set ExpiryDate = 'Nov 30, 2024' Where PlanInternalno = 905

delete From SurvivalBenefit where PlanInternalno = 771

insert into SurvivalBenefit(PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment, PremiumPayingTerm)
select 771, SurvivalBenefitInternalNo - 1000000, Term, Month, Installment, PremiumPayingTerm from SurvivalBenefit where PlanInternalno = 871

delete from BasicPremium Where PlanInternalno in (871, 771)

Update InsurancePlan Set BonusType = '745' Where PlanInternalno = 745
