Re: Combining Values

imani_technology_spam@xxxxxxxxx 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.
.