I also incurred same error msg "Error converting data type nvarchar to numeric", solved converting non-numeric column to numeric

Problem: TableA.EmpID = TableB.EmployeeID

Here TableA.EmpID is varchar datatype and in...