how to concatenate rows and join in another table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » how to concatenate rows and join in another...

how to concatenate rows and join in another table

Rate Topic

Display Mode

Topic Options

Author

Message

ernesto.yandoc

Posted Wednesday, January 16, 2013 3:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 6:01 PM
Points: 2, Visits: 1

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.

Post #1407711

Bhuvnesh

Posted Wednesday, January 16, 2013 3:38 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1407727

« Prev Topic | Next Topic »

Permissions