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 |
|
palavue
Starting Member
1 Post |
 Posted - 2014-03-20 : 14:29:17
|
| I'm working on a query that is asking to return data on dependents which a person can have 0-many, in a single row but sep columns. The dependent data I need to include are Dep First Name, Dep Last Name, Dep Relationship.So my result should look something like this:EEID| DepFirstName| DepLastName| DepRelationship| DepFirstName| DepLastName| DepRelationship121 Billy Larson Spouse Alison Larson ChildHow do I do this with SQL? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-03-20 : 16:14:14
|
| http://www.sqlservercentral.com/articles/Best+Practices/61537/http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
Return multiple values in 1 row sep column