|
StephenD
Senior Member
Australia
1044 Posts |
 Posted - 07 February 2012 : 21:16:07
|
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!
|
|
Need to append text fields into one field
