Solved

Stored procedure error

Posted on 2013-11-08
2
227 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 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 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