Conversion failed when converting the nvarchar value ‘A35’ to data type int


This is my stored procedure, that I am trying to execute.

Create Procedure CAMP_UpdateCaseProfileID as

update crcase

set crcase.UsrProfileNumber = CAMPProfileNumber.ProfileNumberCD ,crcase.UsrManufacturerID = CAMPProfileNumber.ManufacturerID ,crcase.UsrTapeModelID = CAMPProfileNumber.TapeModelID ,crcase.UsrSerialNbr = CAMPProfileNumber.SerialNbr ,crcase.UsrPRegNbr = CAMPProfileNumber.RegistrationNbr ,crcase.UsrCAMPLastActuals = current_timestamp

from CAMPProfileNumber

where crcase.UsrProfileNumber is not null and crcase.CompanyID = 2

GO

After creating the procedure the error I am receiving is:

“Msg 245, Level 16, State 1, Procedure CAMP_UpdateCaseProfileID, Line 4 [Batch Start Line 2] Conversion failed when converting the nvarchar value ‘A35’ to data type int.”

Please Help!