SQL Unique Concatenation

• gsanchezbiz

  SSC Enthusiast

  Points: 120

  More actions

  December 8, 2009 at 4:14 am

  #228400

  Hi, we are assigned to create a Fixed Length string composed of a header detail.

  My issue is: How do I concatenate Details to Header in order to create a single row to the database? I'm using MS SqL2008

  Example:

  Header:

  OrderID DetailCount

  G19902 2

  Detail:

  OrderID OrderDetID

  G19902 XX08

  G19902 XY07

  G19902 XY04

  Result:

  G19902 XX08 XY07 XY04

  Hope I can find help here..

  Thanks

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  December 8, 2009 at 4:49 am

  #1089113

  Try this link

  http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

  ---

  
  Clear Sky SQL
  My Blog[/url]

• gsanchezbiz

  SSC Enthusiast

  Points: 120

  More actions

  December 8, 2009 at 10:02 pm

  #1089646

  Hi Dave,

  That is exactly what I needed. Thanks for the link.:-)