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 |
|
Gratin
Starting Member
6 Posts |
 Posted - 2008-02-25 : 08:09:33
|
| Good afternoon,Our application is a kind of Wiki in 3 languages. We store it in 2 tables: - tblMenu (MenuID, TitleEN, TitleFR, TitleSP, ...)- tblTopic (TopicID, MenuID, Language, Description, Date, ...)We would like to have side by side the 3 descriptions. Is this possible to *merge* the 3 corresponding records in tblTopic (let's say with MenuID = 1) into one output record ?Thank you,Phil. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-25 : 08:11:30
|
Yes. Convert to VARCHAR and concatenate them.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
|
|
|
Merge sub-records, is this possible ?