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!

MS Sql Server LazyDBA home page