title: SQL Server how to turn number of rows to column value?
body: <p>I have three rows return from a table as below:</p>
  
  <pre><code>select ID 
  from service
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>ID 
  --
  1 
  2
  3
  </code></pre>
  
  <p>How can I return output like below:</p>
  
  <pre><code>count  |    IDs 
  -------+----------
  3      |    1,2,3
  </code></pre>