Line number in error message doesn't match up with line number in code

• water490

  Ten Centuries

  Points: 1180

  More actions

  October 18, 2025 at 12:30 am

  #4673935

  Hi everyone

  I have a 1000 plus line query and I am getting an error:

  Msg 8115, Level 16, State 6, Procedure dbo.TestQuery, Line 1036 [Batch Start Line 2]
  Arithmetic overflow error converting float to data type numeric.

  It says line 1036 but when I go to that line I get something that can't possible cause an error.  Line 1036 is part of a comment.

  Is there a way to know the actual line that caused the failure?  That way I can troubleshoot the issue.

  Thank you