subselect join

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  April 17, 2009 at 2:33 pm

  #203722

  I have a table with 3 fields, member,seq, and results that looks like this

  member seq results

  1001add it

  1001test

  1002fortwo

  1002moretw

  1003NULL

  20012test1

  20022test2

  20022testit3

  What I want is a to concatenate results grouping by member and seq

  so I should get

  member seq results

  100 1 addit test

  100 2 fortwo moretw

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 17, 2009 at 2:43 pm

  #979983

  Take a look at this, http://www.sqlservercentral.com/Forums/Topic695359-338-1.aspx

  Should get you what you need.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon