how to concatenate rows and join in another table

• ernesto.yandoc

  Grasshopper

  Points: 16

  More actions

  January 16, 2013 at 3:02 am

  #266992

  Hi to all,

  Please bear with me. anyways, this is the tables i have

  Table1

  Name Company ID

  Mike ABC 1

  Joey CBA 2

  Table2

  OtherVisaID TypeID Remarks

  1 1 test1

  1 2 test2

  2 3 test3

  2 2 test4

  2 1 test5

  Table3

  TypeID Description

  1 US

  2 UK

  3 SG

  Result should be like this..

  ID Name Company List of Visa

  1 Mike ABC US;UK

  2 Joey CBA US;UK;SG

  so as you can see it was separated by ";" hope you understand my question..

  thanks in advance.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 16, 2013 at 3:38 am

  #1577737

  Hi Welcome to SSC forum,

  please Dont cross post , it waste the time of people

  the original thread is http://www.sqlservercentral.com/Forums/Topic1407712-392-1.aspx

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)