将 numeric 转换为数据类型 numeric 时发生算术溢出错误
***********************************************************************
表机构：
CREATE TABLE [dbo].[L070806] (
[record_id] [int] IDENTITY (1, 1) NOT NULL ,
[input_date] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Acq_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[Acq_trn] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Ctr_trn] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Iss_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[Compl_flag] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[TX_code] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[TX_type] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[Acq_postdate] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Ctr_postdate] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Iss_postdate] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[MTI] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[Proc_code] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Tran_acc] [char] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[Tran_amt] [numeric](12, 2) NULL ,
[Setm_amt] [numeric](12, 2) NULL ,
[Acq_DTM] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[Ctr_DTM] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[Conv_rate] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Act_date] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Act_time] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Mer_type] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[Entry_mode] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[Cond_mode] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fee_value_online] [char] (9) COLLATE Chinese_PRC_CI_AS NULL ,
[Acq_ins] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[Forw_ins] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[Ref_no] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[Auth_code] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Rep_code] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[Term_id] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Mer_id] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[Mer_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[rej_code] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[tran_curr] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[setm_curr] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[Recv_ins] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_Comm_s121] [numeric](6, 4) NULL ,
[ORIG_POSTDATE_S121] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[is_bank_local_s121] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[fee_cr_dr_flag_s121] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[adjust_credits_fee_s121] [numeric](12, 2) NULL ,
[adjust_debits_fee_s121] [numeric](12, 2) NULL ,
[orig_tran_amt_s121] [numeric](12, 2) NULL ,
[orig_tx_code_s121] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[Orig_acq_trn] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Orig_acq_dtm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Orig_ctr_trn] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[orig_ctr_dtm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ORIG_REF_NO] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[ESW2_TRN_S127] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[JETS_TERM_ID_S127] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[JETS_BANK_S127] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[JETS_TRN_S127] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[JETS_ORIG_TRN_S127] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[ESW1_P037_S127] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[ESW1_ORIG_P037_S127] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[ESW1_BANK_S127] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[Oal_id] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[branch] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[rel_bank] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[s2nd_bank] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[s2nd_acc_branch] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[s2nd_acc_number] [char] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[tran_acc_branch] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[jet_ssn] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[real_iss_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[real_acq_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[gbl_loc] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[cardcenter_acq_iss] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[forward_backward] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[direct_yes_or_not] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[cut_yes_or_not] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[adjust_yes_or_not] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[iss_credits_amt] [numeric](12, 2) NULL ,
[iss_debits_amt] [numeric](12, 2) NULL ,
[acq_credits_amt] [numeric](12, 2) NULL ,
[acq_debits_amt] [numeric](12, 2) NULL ,
[iss_credits_fee] [numeric](12, 2) NULL ,
[iss_debits_fee] [numeric](12, 2) NULL ,
[acq_credits_fee] [numeric](12, 2) NULL ,
[acq_debits_fee] [numeric](12, 2) NULL ,
[acq_credits_ld_fee] [numeric](12, 2) NULL ,
[acq_debits_ld_fee] [numeric](12, 2) NULL ,
[ctr_credits_amt] [numeric](12, 2) NULL ,
[ctr_debits_amt] [numeric](12, 2) NULL ,
[ctr_credits_fee] [numeric](12, 2) NULL ,
[ctr_debits_fee] [numeric](12, 2) NULL ,
[ctr_credits_ld_fee] [numeric](12, 2) NULL ,
[ctr_debits_ld_fee] [numeric](12, 2) NULL ,
[real_credits_fee] [numeric](12, 2) NULL ,
[real_debits_fee] [numeric](12, 2) NULL ,
[stand_credits_fee] [numeric](12, 2) NULL ,
[stand_debits_fee] [numeric](12, 2) NULL ,
[Mer_bank] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_name_from_tbl] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_acct_from_tbl] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_open_no_from_tbl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_open_nm_from_tbl] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[mer_loc_comm] [numeric](6, 4) NULL ,
[mer_gbl_comm] [numeric](6, 4) NULL ,
[tx_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[orig_tx_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[old_Acq_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[old_Iss_code] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[Sett_flag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[Log_from_sw] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
*********************************************************************
[解决办法]
晕倒，这个表让我开眼界啦。
好好检查存储过程吧，100%是参数与列对不上，错位了。
