multiple row data added to a single row in another table based on ID

Asked Jul 18 '16 at 09:43

Active Jul 18 '16 at 09:51

Viewed 15 times

I am using SQL Server 2008 R2.

I am stuck on the following situation and I am wondering how to achieve this.

table1:

ID   Data
1     Alpha
1     Beta
1     Gamma
2     Alpha
2     beta
3     Gamma

taking the data from table one and showing it like this

Table2:

ID   Data
1    Alpha, Beta, Gamma
2    Alpha, beta
3    Gamma

edited Jul 18 '16 at 09:51

asked Jul 18 '16 at 09:43

Glngrnr

@tim-schmelter: I think this is a duplicate of: http://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-sql-server – a_horse_with_no_name Jul 18 '16 at 09:52
@a_horse_with_no_name: could be, feel free to reopen/close it again :) – Tim Schmelter Jul 18 '16 at 09:53

0 Answers0