Concatenating string values of multiple rows with same ID

• jothikrishna36

  SSC Veteran

  Points: 292

  More actions

  February 11, 2010 at 6:01 pm

  #215566

  Hi All,

  Here is the situation:

  I have table with the data

  For eg:

  ID LineNo Text

  100 1 aaa

  100 3 bbb

  100 2 ccc

  200 1 ddd

  200 2 eee

  I need the result as

  ID Text

  100 aaa ccc bbb

  200 ddd eee

  I tried with the (@i=@i+column) method, but I need ID as well.

  Could anyone please help me out with possible query WITHOUT CURSOR.

  Env: SQL Server 2000

  Thanks in advance

  Jothi Krishna

• arun.sas

  SSChampion

  Points: 11831

  More actions

  February 11, 2010 at 8:20 pm

  #1117871

  Hi Jothi Krishna,

  Refer this link: discussed with same topic.

  http://www.sqlservercentral.com/Forums/Topic862480-169-1.aspx#bm863021

• jothikrishna36

  SSC Veteran

  Points: 292

  More actions

  February 11, 2010 at 8:56 pm

  #1117879

  Thank you very much for the timely help. 🙂

  have a good one