title: SQL Server: how to remove last comma after combining rows using XML Path
body: <p>I found a way to combine multiple row's into one row which is comma separated but now I would like to remove the last comma. </p>
  
  <pre><code>CREATE TABLE supportContacts 
  (
     id int identity primary key, 
     type varchar(20), 
     details varchar(30)
  );
  
  INSERT INTO supportContacts (type, details)
  VALUES ('Email', 'admin@sqlfiddle.com'),
         ('Twitter', '@sqlfiddle');
  </code></pre>
  
  <p>This query combines types, but I want to now remove the last comma:</p>
  
  <pre><code>SELECT top (2) 
      type + ', ' AS 'data()'
  FROM  
      supportContacts
  ORDER BY 
      type DESC
  FOR XML PATH('')
  </code></pre>
  
  <p>This is the current result:</p>
  
  <pre><code>Twitter, Email,
  </code></pre>