?
Solved

Stored procedure error

Posted on 2013-11-08
2
Medium Priority
?
244 Views
Last Modified: 2013-11-18
Using MS SQL Server 2008.

When i run my stored procedure i get a "divide by zero error on line 54".

How can i work out which line it is?  Should i physically count the lines in the stored procedure until i come to 54?

Is it as simple as that?

/thanks
0
Comment
Question by:soozh
2 Comments
 
LVL 11

Accepted Solution

by:
Louis01 earned 2000 total points
ID: 39632855
Each "GO" restarts the line count.
Hope that helps.
If not, post your code.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39633037
can we see the code?
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question