Posted by Clive Swan on 08/13/07 09:44

Hi,

My GIS software has a tool to count the number of points within a
grid.
This is fine for small recordset, when you get into the tens thousands
it
becomes unfriendly.

It must be possible (more efficent??) to do a select statement from
the two tables and insert the result into a column??

Table Property has thousands of records that fall within each record
of Table Ward.

Expect the SQL would be

SELECT [Property].BedRmNumber FROM [Ward].LA
WHERE [Property].LA = [Ward].LA

Surely this would need a loop.

Could anyone help???

Thanks

clive

• Next in forum: urls/ free downloadbable tutorials
• Prev in forum: Linked Server Headache (Access)
• Thread view: INNER JOIN - INSERT

[Reply to this message]