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