At 23:29 18/07/2006, you wrote:
Thanks, Igor, you've inspired and saved me yet again. The subqueries you had
used for the x/yEnd did not work, but the rest did and I have that maxim
information beforehand anyway. Here's how it shook down:
select
cast(cast((xStart+xEnd) as double)/2/15518.5 as integer) cellX,
cast(cast((yStart+yEnd) as double)/2/15603.171875 as integer) cellY,
max(score)
from results_1
group by cellX, cellY;
change divisions /2 /15518.5 by *0.5 *0.000064439 or better
*0.000032219. Similar for cellY.
-----------------------------------------------------------------------------------------------------------------------------
La diferencia entre la teoria y la practica es que en teoria no hay,
pero en la practica si
