Concatinate a coloum values

• sagavb

  Grasshopper

  Points: 14

  More actions

  October 22, 2009 at 12:12 am

  #100687

  Hi Buddies,

  I just want to concatinate a column values.

  For an example,

  Table A

  --------

  ID Name DeptID

  ---------------

  1 Mr.X DeptA

  2 Mr.Y DeptB

  3 Mr.Z DeptC

  In the above table, i just want to concat all deptid as a single row.

  So, My result would be something like this,

  DeptA;DeptB;DeptC

  Anybody can help me on this?

  Thanks

  Saga

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  October 22, 2009 at 12:27 am

  #1069247

  try this

  declare @outvar nvarchar(100)

  set @outvar=''

  SELECT @outvar=@outvar + ', ' + deptid FROM tableA

  select @outvar

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  October 22, 2009 at 1:24 am

  #1069259

  Try this link

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

  ---

  
  Clear Sky SQL
  My Blog[/url]