[dba-VB] Merge rows

Not 50 million, though still a lot.  I just ran a query which shows 3.086 million individduals with 
multiple records.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> 50 Million!
> 
> Max
> 
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: 21 September 2009 23:55
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] Merge rows
> 
> On the assumption that you don't really care which record you get if there
> are conflicts, I'd 
> build a new table from:
> 
> Select Distinct, KeyField, Max(fld2),Max(fld3)..........
>