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 |
|
ktech
Starting Member
7 Posts |
 Posted - 2014-04-29 : 23:08:34
|
| Hi All,I am not sure if that is possible.Part of my query that select patient's information, such as Name DOB,ID,and insurance, Some patients have multiple insurance, the result display multiple rows for those patients, such asPatient A ID Name DOB insurance 1 Patient A ID Name DOB insurance 2Patient A ID Name DOB insurance 3 I need one patient one row, but with all the insurances:Patient A ID Name DOB insurance 1 ,insurance 2,insurance 3Is it possible?Thank you so much for any helps!!! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
ktech
Starting Member
7 Posts |
Posted - 2014-04-30 : 11:24:25
|
| khtan,Thanks a lot!!That helps. Now I need figure out how to adapt it into my complex query. |
 |
|
|
|
|
|
Can I display multiple value in one row