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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-10 : 07:45:26
|
| Natarajan writes "I have two tables namely "Orders" and "External Numbers". OrderID is pkey in Orders and fkey in External Numbers.I need to display values in Listview from both Orders and External Numbers tables.For eg. I will display in the Listview "Orderid, Order Name from Orders Table and "External No from External Numbers table.I might get a situation where I will have 3 records in External Numbers table for one order.It will be like this.OrderID OrderName External No.1 aaa 12 aaa 23 aaa 3I want the output asOrderID OrderName External No.1 aaa 1,2,3I should display as comma separated.Help me in solving this." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-12-10 : 08:49:18
|
| Well then search here for CSV...it's been solved before. |
 |
|
|
|
|
|
Displaying columns as comma Separated.