Re: HELP: Database Record Rollup

Marc A. Lefebvre US-775 wrote:

> I have a source database table that has the form:
>
> ID TYPE TEXT
> 1 1 AAAA
> 2 1 BBBB
> 3 2 CCCC
> 4 2 DDDD
> 5 2 EEEE
>
>
> And I need to output in the following form:
>
> TYPE TEXT
> 1 AAAA BBBB
> 2 CCCC DDDD EEEE
>
>
> Where the TEXT field is concatenated based on type. What SQL
> statement would produce such an output?
>
> Thanks!
>
> Marc

None. Write a stored procedure.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)