Posted by imani_technology_spam@yahoo.com on 06/30/07 02:47

I wish I could, but this is a data migration. I HAVE to put this
stuff in the table. The customer requires it. More specifically,
Commerce Server requires it.

On Jun 29, 6:55 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> imani_technology_s...@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.- Hide quoted text -
>
> - Show quoted text -

[Back to original message]