<div>
I've used the method in this article many times with great results.<br />
<a href="http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string" rel="ugc">http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string</a>
</div>


I've used the method in this article many times with great results.
http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string [http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string]

<div>
<a href="https://www.experts-exchange.com/questions/22744569/Rows-To-Columns.html?sfQueryTermInfo=1+10+column+row+sql" rel="ugc">https://www.experts-exchange.com/questions/22744569/Rows-To-Columns.html?sfQueryTermInfo=1+10+column+row+sql</a><br />
<br />
Try this
</div>


https://www.experts-exchange.com/questions/22744569/Rows-To-Columns.html?sfQueryTermInfo=1+10+column+row+sql [https://www.experts-exchange.com/questions/22744569/Rows-To-Columns.html?sfQueryTermInfo=1+10+column+row+sql]

Try this

<div>
<div class="content wysiwyg-content">
I have a table &nbsp;called [table_a] and it has a column name [product], <br />
<br />
when i run this statement &nbsp;<br />
'SELECT product FROM table_a'<br />
<br />
it returns<br />
<br />
product<br />
A0023<br />
GG990<br />
HHG176<br />
KKJ1212<br />
<br />
what statement would i need to return one record in the below format<br />
<br />
A0023,GG990,HHG176,KKJ1212<wbr /><br />
<br />

</div>
</div>


I have a table  called [table_a] and it has a column name [product], 

when i run this statement  
'SELECT product FROM table_a'

it returns

product
A0023
GG990
HHG176
KKJ1212

what statement would i need to return one record in the below format

A0023,GG990,HHG176,KKJ1212



put a colum of data and insert it into a single field with comma seperators

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.