Re: Concatenate Column Values from Multiple Rows into a Single Column

Rad Thibodayox wrote:

> I would like to combine a field's values from multiple records in a
> single field. For example:
>
> Last First Code
> ------- --------- ----
> Lesand Danny 1
> Lesand Danny 2
> Lesand Danny 3
> Benedi Eric 7
> Benedi Eric 14
>
> Result should look like:
>
> Last First Codes
> ------- --------- -----
> Lesand Danny 1,2,3
> Benedi Eric 7,14
>
>
> Any help would be appreciated,
>
> Dwayne

This is school work and as you can probably surmise we don't do other people's homework and exams.

But you are entitled to a hint ... and the hint is that this requires a stored procedure. Think cursor. Think loop.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)