Need to append text fields into one field

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/70122?pagenum=1
05 November 2025, 12:58

Topic


StephenD
Need to append text fields into one field
07 February 2012, 21:16


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!

 

© 2000-2021 Snitz™ Communications