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,
Brannon King
wrote:
I'm wondering if the following query can be done as a single query
rather than running it in a (nested) loop.
Suppose a database with five columns; xStart, yStart, xEnd, yEnd,
score. I need the maximum score at the midpoint of the line quantized
to a 64x64 grid. Psuedo
2 matches
Mail list logo