title: Concatenate column values as single value SQL Server 2005
body: <p>I have a table with a column:</p>
  
  <pre><code>|-------------|
  | ColumnName  |
  |-------------|
  | Value One   |
  | Value Two   |
  | Value Three |
  | Value Four  |
  | Value Five  |
  |-------------|
  </code></pre>
  
  <p>I will declare a variable,</p>
  
  <pre><code>DECLARE @ColumnNameList VARCHAR(MAX)
  </code></pre>
  
  <p>and I should find the below value in my variable</p>
  
  <pre><code>'Value One,Value Two,Value Three,Value Four,Value Five'
  </code></pre>
  
  <p>Can anyone help me out in doing this?</p>
  
  <p>Thanks in advance.</p>