I am getting Arithmetic overflow error converting varchar to data type numeric.
Declare @result varchar(max)
Select @Result= abs(Convert(numeric(11,2),@RegisterReading) - Convert(numeric(11,2),@ProposedReading))
Hi chetan,
It seems like the @RegisterReading or @ProposedReading data size specified for the columns is less compared to the data being used.
So change the length of the numeric(11,2).
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.