Posted by Ed Murphy on 06/30/07 01:55

imani_technology_spam@yahoo.com wrote:

> I need to do something that goes against normalization, but it is what
> the client wants. Let's say one person has several addresses. I need
> to be able to take each of those addresses and combine them into one
> field. So I need to take this:
>
> John Doe | Address 1
> John Doe | Address 2
> John Doe | Address 3
>
> And combine them into this:
>
> John Doe | Address 1; Address 2; Address 3
>
>
> Do I need a cursor for this?

Do this in the reporting layer (e.g. Crystal Reports) if at
all possible.

[Back to original message]