How to group this?

• bull2000

  SSC Eights!

  Points: 841

  More actions

  March 20, 2005 at 6:35 pm

  #61666

  the data looks like this:

  PartNo                 Location

  P1                       Loc1

  P1                       Loc2

  P1                        Loc3

  P2                        Loc2

  P2                        Loc4

  I need to list all the locations for each part:

  P1                        Loc1,Loc2,Loc3

  P2                        Loc2,Loc4

  Is there a way that can be done without using cursor and temp table?

  thanks a lot.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 21, 2005 at 2:14 am

  #547956

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

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• bull2000

  SSC Eights!

  Points: 841

  More actions

  March 21, 2005 at 6:48 am

  #547989

  Thanks a lot Frank.