using UPDATE with GROUP By

[william humphrey]

Same thing with this:

UPDATE data_address SET d_address_LineNumber = 1 WHERE
d_address_LineNumber IN (select d_address_LineNumber from
(select d_address_LineNumber, d_address_clients_ref, count
(d_address_clients_ref) as SomeName
from data_address
group by d_address_LineNumber,d_address_clients_ref
having SomeName = 1)
)

All 8150 rows are affected an set to 1. GEEZ!