'Arithmetic overflow error converting numeric to data type numeric'

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  September 17, 2012 at 4:49 am

  #1538507

  No, there is sql trace running for capture error results. I thought application side might be issue? pl. check error page here.

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  September 17, 2012 at 5:56 am

  #1538537

  ananda.murugesan (9/17/2012)

  ---

  No, there is sql trace running for capture error results. I thought application side might be issue? pl. check error page here.

  I'm unable to reproduce the error with the examples you've given:

  /*

  TRUNCATE TABLE SIL_TRAN_D

  TRUNCATE TABLE SIL_TRAN_H

  */

  exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1003|2012083014645|37100666|17 Sep 2012 12:25:46'

  exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1004|2012083014645|37100666|17 Sep 2012 12:25:47'

  exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1005|2012083014645|37100666|17 Sep 2012 12:25:48'

  exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|1|4DA-TE-304A/B/D'

  exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|2|30 Aug 2012-14646'

  exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|3|JGDTB'

  exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|4|FCC/PRV'

  exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1005|2012083014645|1|10|4'

  SELECT * FROM SIL_TRAN_H

  SELECT * FROM SIL_TRAN_D

  I've run this script twice - with the original values - which populates the two tables, and with the slightly modified values I've posted above - which updates the original values. The only difference between your script and mine is the two functions which you haven't yet posted.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden