Modify Data Type Loan & Deposito
ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate] ALTER COLUMN totalEarlyPrepayment numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate] ALTER COLUMN totalOutstanding numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate] ALTER COLUMN totalEarlyPrepayment numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate] ALTER COLUMN totalOutstanding numeric(32,2); ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation] ALTER COLUMN totalEarlyPrepayment numeric(32,2); ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation] ALTER COLUMN totalOutstanding numeric(32,2); ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation] ALTER COLUMN balance numeric(32,2); ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation] ALTER COLUMN ew numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate] ALTER COLUMN balance numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate] ALTER COLUMN ew numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate] ALTER COLUMN balance numeric(32,2); ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate] ALTER COLUMN ew numeric(32,2);
Leave a Comment