Merging rows, same table

  • Thread starter Thread starter Nicky
  • Start date Start date
N

Nicky

I have a table of data, 3 fields A record number, a note, and date the
note was added.

Old table looks like this

RecordID DateAdded Notes

11234-1 11/1/2006 Note about this record
11234-1 12/1/2006 Another note
11237-1 11/1/2006 Note about this record

I need for the new table to look like this

RecordID Notes
11234-1 11/1/2006 Note about this record, 12/1/2006 Another note
11237-1 11/1/2006 Note about this record

I understand how to merge the values of the columns, but don't know how
to merge the values of the rows. Table is large (300K rows.)

I'm trying to concatinate information, and then importing this data
into another application and retain some history data (from date and
notes fields.)

Any ideas???

Thanks,

-nick
 
Thanks Doug.

The code looks promising.

The denormalization is OK in my case. I'm transitioning systems, the
notes and data fields are needed for data preservation. I have bits and
pieces of data in many tables that I'm trying to distill down to just
few tables.

I've been experimenting with unions, and getting some mixed results,
I'm happy to see I have some options.

-nick
 
Thanks Doug.

The code looks promising.

The denormalization is OK in my case. I'm transitioning systems, the
notes and data fields are needed for data preservation. I have bits and
pieces of data in many tables that I'm trying to distill down to just
few tables.

I've been experimenting with unions, and getting some mixed results,
I'm happy to see I have some options.

-nick
 
Back
Top