Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mccjeremy
Starting Member
1 Post |
 Posted - 2005-12-13 : 16:30:39
|
| Hi, say I have the fields: ID, order_number (tells me the order of the line_text eg. order_number 0 = first line) and line_text. It would look like below:ID order_number line_text1 0 Hello2 0 Greetings3 0 Welcome4 0 Hello4 1 there4 2 friendI want query so that it concatenates the line_text that has the same ID, which will also eliminate the need for order_number eg:ID line_text4 Hello there friendI have seen other topics on this but I don't quite understand them. Could someone please help me! |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Concatenating rows by column