Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Hi Friends,
 
I m getting the below error while i m running a procedure
 
Error : Arithmetic overflow error converting expression to data type int.
 
Here is my query
 
DECLARE @COUNT INT, @INVOICENO VARCHAR(100)
 
SELECT @COUNT = isnull( MAX(CONVERT(BIGINT,replace ( substring(INVOICENO,0,case when charindex('-',INVOICENO,0)  > 0 then charindex('-',INVOICENO,0) else len (Invoiceno) + 1 end  ),' ', ''))),0) ,@EmployerId = MAX(SUPERVISORNAME) fROM TBL_NEW_TIMESHEET
WHERE CONTRACTORID = @CONTRACTORID AND INVOICENO IS NOT NULL
 
Thanks
Posted 17-Jan-13 16:25pm
Edited 17-Jan-13 16:33pm
v2
Comments
PIEBALDconsult at 17-Jan-13 23:13pm
   
See which values it fails for.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 400
1 Sergey Alexandrovich Kryukov 301
2 Shai Vashdi 240
3 OriginalGriff 155
4 Tadit Dash 135
0 Sergey Alexandrovich Kryukov 9,225
1 OriginalGriff 5,395
2 Peter Leow 4,100
3 Maciej Los 3,540
4 Abhinav S 3,333


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid