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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)