Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Need to append text fields into one field

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
StephenD 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!

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.01 seconds. Powered By: Snitz Forums 2000 Version 3.4.07