Is there an aggregate function in T-SQL to concatenate strings?

Question

SQL

My query returns result like this:

Employee   PollNumber
------------    ----------
Alex      12        
Alex      13
Alex      14
Bob       15
Bob       16
Sam       17

I need to write a query that groups Employee together and displays a list of PollNumbers:

Employee    PollNumbers
------------    -----------
Alex      12, 13, 14
Bob       15, 16
Sam       17

For SQL 2017 there is STRING_AGG(), but I have a 2014 version, please tell me the query option

Answer 1

for xml
examples
Applies to: yesSQL Server (all supported versions)
from 2005 version. did not exist in 2000