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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-12-01 : 05:05:42
|
| Hi there,I know there's a way to do this but I can't for the life of me remember. The database I'm working on takes calls from clients. Each call is logged and can have muliple notes from a different table: C.Call N.Note1 This is Note one1 This is Note Two2 This is note 12 This is note 2 ....etcI want to find a way to concat each note row together for each call so the rows don't repeat, like this:C.Call N.Note1 This is Note one , This is Note Two2 This is note 1, This is note 2Does anyone know how I can achieve this?Many thanks for any help:) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
contatinating each row from field into one row