Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Returning multiple rows as one


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@hotmail.com> wrote:

> 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
looking at.

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
efficient.

James

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc