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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to put 1-N Relation in a delimited column?

Author  Topic 

Cyclonik
Posting Yak Master

114 Posts

Posted - 2006-09-05 : 11:38:30
I am curious how I might go about doing the following.

I have TableA and it relates to TableB 1-N. I would like to to select a set of rows from TableA and create a column of the joined rows from TableB as a delmited string.

e.g. 12, 34, "values, from, columna, tableB"

Hope thats clear.

Christian

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-05 : 11:44:16
Take a look at this topic
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53293


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -