The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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!
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