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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2010-12-17 : 08:30:26
|
| I have 2 tables. One table is the parent table to the other table. Here is what TableParent looks like:ParentID Date 1 12/8/2010Here is TableChild:ChildID ParentID Result 1 1 Test 1 2 1 Test 2 3 1 Test 3I want to write a SQL statement that will concatenate the 3 rows in TableChild as one column. So here is what I wanted returned:ParentID myResult 1 Test 1 Test 2 Test 3How can I do this?Thanks,Bob |
|
|
|
|
|
Need help with SQL query