Need to append text fields into one field - Postet den (722 Views)
Senior Member
StephenD
Innlegg: 1044
1044
Looking for a way in SQL to merge the following row data into a new table if possible:

Source table:
ed_id (int 4) (primary key)
emp_id (int 4)
general_data (varchar 60)

Looks like:
ed_id emp_id general_data
100 1201 Commenced on 29/01/2011 and
101 1201 reports to John Smith in
102 1201 comms section
103 1202 New starter arriving on 1st
104 1202 June 2012

Target table to be:

emp_id
general_data

And look like:
emp_id general_data
1201 Commenced on 29/01/2011 and reports to John Smith in comms section
1202 New starter arriving on 1st June 2012

Can't seem to find a merge tool that will do it in one go.
Source table has 16K rows
Cheers!

lblNoReplies

Du må legge inn en melding