cancatenate columns

• bull2000

  SSC Eights!

  Points: 841

  More actions

  January 18, 2008 at 1:41 pm

  #185701

  Hello,

  I am trying to have an table looks like

  Part_number Desc

  P1 New_part

  P1 Old_part

  P2 something

  P2 more

  now I need the output as

  P1, "New_part;Old_Part"

  P2, "something;more"

  basically, I need to cancatenate the Desc column when the Part_number is the same.

  I know the table doe not make much sense. but I just use it as an example.

  Thanks a lot

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  January 18, 2008 at 1:54 pm

  #769882

  take a look at this thread: http://www.sqlservercentral.com/Forums/Topic436572-338-1.aspx