Joseph:

Just see whether you are getting a zero in the denominator part.

run something like this select and find out which calculation (Calc?) returns zero.

SELECT (a.X1+ 0.000111 -a.X0) * (a.X2-a.X0) As Calc1,
(a.X1+0.000111 - a.X0) * (-111.9528 - a.X0) As Calc2,
(a.X1+0.000111 - a.X0) * (a.X2 - a.X0) As Calc3,
(a.X1+0.000111 - a.X0) * (-111.9528 - a.X0) As Calc4
FROM (((pn_alignment_sheet a
inner join pn_alignment_sheet b
on a.id = b.id) inner join pn_alignment_sheet c on b.id = c.id) inner join
pn_alignment_sheet d on c.id = d.id)

----
John


-----Original Message-----
From: Bernita Joseph [mailto:[Email Address Removed] Tuesday, October 22, 2002 8:59 AM
To: LazyDBA.com Discussion
Subject: SQL SERVER QUESTION,divided by zero error, urgent please!!!!


HI List,

I'm getting a zero divided by error. The script look something like this:

SELECT DISTINCT d.ID, d.alignment_sheet_name FROM (((pn_alignment_sheet a
inner join pn_alignment_sheet b
on a.id = b.id) inner join pn_alignment_sheet c on b.id = c.id) inner join
pn_alignment_sheet d on c.id = d.id)
WHERE
((((a.Y2-a.Y0-((a.Y1-a.Y0)/((a.X1+0.000111)-a.X0))*(a.X2-a.X0))>0)
AND ((33.36-a.Y0-((a.Y1-a.Y0)/((a.X1+0.000111)-a.X0))*(-111.9528-a.X0))>0))
OR (((a.Y2-a.Y0-((a.Y1-a.Y0)/((a.X1+0.000111)-a.X0))*(a.X2-a.X0))<=0)
AND
((33.36-a.Y0-((a.Y1-a.Y0)/((a.X1+0.000111)-a.X0))*(-111.9528-a.X0))<=0)))


Thanks!


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page