In a query some of the records of foreign key return multiple records.
Is it possible to return the data as a single row for each foreign key
and a delimited value for those with multiple records?
On 7 Jun, 11:20, Robin9876 <robin9
> In a query some of the records of foreign key return multiple records.
> Is it possible to return the data as a single row for each foreign key
> and a delimited value for those with multiple records?
I can think of two ways of doing this Robin.
The way I would choose to do it depends on the volume of data you are
For low volume I would probably go for a user defined funtion, you
could pass the parent record in the foreign key relationship to it,
have it build you delimited string and pass it back as a varchar
field. The function call could be done as a column in your resultset.
If you are dealing with larger volumes I would most likely create a
stored procedure to get all foreign key records that correspond to
your query, created delimited strings from them and using insert exec,
write them to a temp table. Then you can join this temp table to the
original resultset. It's a little more long winded but it is far more