Thread: String or binary data would be truncated in microsoft.public.sqlserver.programming

  Hello: I'm getting this error message in SQL 2005 Standard when I run the attached code: Msg 8152, Level 16, State 14, Line 1 String or binary data would be truncated. The statement has been terminated. I did not get this error the first time that I ran this, but I did the second time. The code is designed to increment the NXTSPNUM field in our IV40100 table by one greater than any ORDDOCID field in the SVC00700 or SVC30700...

  123456123456712345678 UNIVTR0000000ORDDOCID 6 + 7 + 8 = 21 21 is bigger than 15 to me. ([NXTSPNUM] [char](15) NOT NULL) To fix the problem, you need to extend the column NXTSPNUM to at least 21 char. However, I think your codes mean adding leading zeros to ORDDOCID and not adding 7's zeros in between. If that is so, you need to change your codes to: Set NXTSPNUM=(SELECT 'UNIVTR' + right(replicate('0',7) +...