Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to concatenate rows and join in another table Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 3:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, January 16, 2013 3:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:36 AM
Points: 2,840, Visits: 3,970
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
Post #1407727
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse