title: SQL Server 2008 Rows to 1 CSV field
body: <p>We're on SQL Server 2008 and I'm trying to figure out if there's a way to have a stored procedure return my results in 1 CSV field</p>
  
  <p>for example:</p>
  
  <pre><code>SELECT TOP 4 carModels
  FROM dbo.Models
  </code></pre>
  
  <p>would return</p>
  
  <pre><code>Jeep
  Honda
  Mitsubishi
  Ford
  </code></pre>
  
  <p>I would like this returned in 1 field like so:
  Jeep,Honda,Mitsubishi,Ford</p>
  
  <p>I know we can do this with an assembly, temp tables, or server side code but would prefer not to go that route. Are there any tips / tricks you could suggest to get the result I'm looking for?</p>