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. 

```
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');

```

This query combines types, but I want to now remove the last comma:

```
SELECT top (2) 
    type + ', ' AS 'data()'
FROM  
    supportContacts
ORDER BY 
    type DESC
FOR XML PATH('')

```

This is the current result:

```
Twitter, Email,

```