using UPDATE with GROUP By

[william humphrey]

That zipped file contains all the data also.

On Sun, Jun 20, 2010 at 11:57 AM, Bart Pietercil
<bart.pietercil at cognosis.be> wrote:
> Hi William,
> downloaded b_I_database.vdb.zip but no data (off course). Without data there is not much I can look at...
>
>
> Bart Pietercil
> CTO Cognosis NV
>
>
>
> On 20 Jun 2010, at 17:54, Bart Pietercil wrote:
>
>> Hm,
>>
>> suspecting a flaw in your logic; can you describe me what you want to do (limited to the tables we're looking at).
>> I have to leave now but I'll try to look at the db and your explanation this evening late or maybe tomorrow
>>
>>
>> Bart Pietercil
>> CTO Cognosis NV
>>
>>
>>
>> On 20 Jun 2010, at 17:22, william humphrey wrote:
>>
>>> 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!
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com