Combine select rows into 1 column

Asked Mar 28 '17 at 18:12

Active Mar 28 '17 at 18:15

Viewed 32 times

I'm sorry, I know others have asked similar questions to this but I read those answers and still couldn't figure this out.

I need to make

Whatever    StudentID   SchoolID    Types    
qw          1           A           c    
we          2           B           a    
we          2           B           r    
ty          3           C           f    
ty          3           C           t    
yu          4           D           k

into

Whatever    StudentID   SchoolID    Types    
qw          1           A           c    
we          2           B           ar    -- concat
ty          3           C           ft    -- concat
yu          4           D           k

Thanks for your help. I tried using xml paths but couldn't figure it out.

edited Mar 28 '17 at 18:15

Juan Carlos Oropeza

47,252
12
78
118

asked Mar 28 '17 at 18:12

eric

1

Hint: `GROUP BY`. – Gordon Linoff Mar 28 '17 at 18:13
1

@hich database are you using? (from xmlpaths I am guessing sql server) – Gurwinder Singh Mar 28 '17 at 18:13
Yes, sql server. And Transact-SQL if that matters. – eric Mar 28 '17 at 18:15

Combine select rows into 1 column

0 Answers0