Posted by Madhivanan on 06/30/07 06:22

If you cant do this in reports, refer this

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Madhivanan


On Jun 30, 10:47 am, "imani_technology_s...@yahoo.com"
<imani_technology_s...@yahoo.com> wrote:
> 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 -- Hide quoted text -
>
> - Show quoted text -

[Back to original message]