In that case, let's provide a link on the subject.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Please make sure that you dive into the "Join the Discussion" link for a particular performance optimization.
As for the dupes, "It Depends" on whether or not you actually need the dupes or not.