Hi,

I need to use Pythagoras theorem on every row in a table. It is to determine the distance between two locations for a job search.

Is it possible to do a square root with llblgen?

Cheers, I.

isn't it :

In algebraic terms, a2 + b2 = c2 where c is the hypotenuse while a and b are the sides of the triangle.

I'm afraid I don't get what you are trying to do ?

Oh yes, I can square the distance (c) and compare that. Thanks.

I was trying to square root c2 to get the actual distance between the two points but this is of course unnecessary.

'ExOp.Sqr' would be a nice addition.

At the moment, my SQL is coming out as...

(([jwdata].[dbo].[tbl_UK-Postcodes].[x] - @LO19153) 
*
 ([jwdata].[dbo].[tbl_UK-Postcodes].[x] - @LO19154))
 +
 (([jwdata].[dbo].[tbl_UK-Postcodes].[y] - @LO19145)
 * 
([jwdata].[dbo].[tbl_UK-Postcodes].[y] - @LO19146))

<= @X2

So its doing each difference twice.

What would be better is...

 SQUARE ([jwdata].[dbo].[tbl_UK-Postcodes].[x] - @LO19153) 
 +
 SQUARE ([jwdata].[dbo].[tbl_UK-Postcodes].[y] - @LO19145)

<= @X2

Please check the following threead: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4642