sql concatenate multiple values

rerycleMarp

New Member
I have designed a view in SQL Server 2008 that displays 2 columns of distinct data in this format:\[code\]Column1 Column2A Text1B Text2B Text3C Text4D Text5D Text6D Text7E Text8\[/code\]What do I have to do to get the view to display only the distinct Column1 values with Column2 values concatenated like this:\[code\]Column1 Column2A Text1B Text2, Text3C Text4D Text5, Text6, Text7E Text8\[/code\]Thanks in advance!
 
Top