Posted by imani_technology_spam@yahoo.com on 07/01/07 23:48

Here's where things get interesting:

John Doe | Address 1
John Doe | Address 2
John Doe | Address 3
Jane Smith | Address 1
Jane Smith | Address 2

The results need to be

John Doe | 3; Address 1; Address 2; Address 3
Jane Smith | 2; Address 1; Address 2

I have no idea how to pull this off.

On Jun 30, 6:39 am, "Marcin A. Guzowski"
<tu_wstaw_moje_i...@guzowski.info> wrote:
> 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.
>
> You have three options:
>
> 1) aggregate concatenation in cursor
> 2) aggregate concatenation in SELECT query
> 3) aggregate concatenation using FOR XML
>
> Option 1) is the safest method.
>
> For option 2) details refer to:http://groups.google.pl/group/microsoft.public.sqlserver.programming/...
>
> Third method:http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/06/871.aspx
>
> --
> Best regards,
> Marcin Guzowskihttp://guzowski.info

[Back to original message]