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 |
|
h2sut
Starting Member
40 Posts |
 Posted - 2008-09-11 : 12:56:34
|
| If i have multiple users in a table. ex:39089 DIANA GEORGE DLCH Dependent Life39089 DIANA GEORGE DLSP Dependent LifeIs there a way to combine the rows into one row. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-11 : 13:04:03
|
| how do you want to combine the DLCH/DLSP values?Be One with the OptimizerTG |
 |
|
|
h2sut
Starting Member
40 Posts |
Posted - 2008-09-11 : 13:12:47
|
| The DLCH/DLSP vaules are the plancodes for the user. SO each user can have up to 38 plan codes. i would assume to assign another column but i not sure if that possible |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-11 : 13:49:54
|
| well if I understand you, it wouldn't be another column it would be 37 columns. Is this for a report/presentation purpose? You just need to decide exactly how you want the results displayed, then if you want help, post the table(s) structure. (ie: post the DDL and expected results) and we can help you. Keep in mind you can't have a differing number of columns for different users so if George there has 2 plan codes but TG has 38, we need to have our results displayed with the same number of columns. Maybe you want to omit the plan codes entirely, or concatenate them in one long csv column, or present them in another result set...Be One with the OptimizerTG |
|
|
|
|
|
|
Multiple Rows into one row.