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 |
ashoky2k_99
Starting Member
2 Posts |
Posted - 2012-01-19 : 16:24:02
|
Hi All,I was wondering if you would be able to help me with a simple query.Here is a table with two fields:Name ParentName1234 1234xy1234 ab1234I would like write a query in SQL Server that yields results like following:1234 1234xy ab1234How do I do this? If you could write a query and send me, I would really appreciate. |
|
X002548
Not Just a Number
15586 Posts |
|
ashoky2k_99
Starting Member
2 Posts |
Posted - 2012-01-19 : 16:53:06
|
@X002548want concatenate all 100 of them, if i have some more rows with diffrent ID, I want to concatenate them too sepearteThanks in advance |
 |
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
|
|