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 |
|
aww77
Starting Member
1 Post |
 Posted - 2007-10-15 : 12:54:20
|
| Hi,I have the result set where for each Pat_id I need all Text in one rowPAT_ID ID Text5 215 Subarachnoid haemorrhage6 218 Cardiac arrhythmiac5 215 Aortic dissection5 215 Heart failuree.g. PAT_ID ID Text5 215 Subarachnoid haemorrhage; Aortic dissection; Heart failure6 218 Cardiac arrhythmiacI can get it so all the Text appears on one line but not the grouping so that it still splits by pat_id.Your help would be appreciated. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
|
|
|
|
|
Converting rows into one column