|
|
Posted by Stephen2 on 07/02/07 10:28
On Jul 2, 12:48 am, "imani_technology_s...@yahoo.com"
<imani_technology_s...@yahoo.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
You could use a WHILE loop to select row by row for each person.
SELECT the COUNT of addresses for the current person into one variable
and build up a text string of the concatenated addresses into another
variable looping round until you've got them all. Then update the
column in the table with the value of the variables.
Navigation:
[Reply to this message]
|