merging multiple rows to a single row

You may refer the below link:

http://beyondrelational.com/modules/24/syndicated/509/posts/12832/tsql-script-generatingconcatenating-values-into-a-comma-separated-string-with-a-grouping.aspx

http://beyondrelational.com/modules/2/blogs/77/posts/11386/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.