InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 02:48:33 GMT20http://www.sqlservercentral.com/Forums/Topic973776-392-1.aspxTry this....SELECT DISTINCT c1.Col1, c1.Col2, STUFF((SELECT ',' + Col3 FROM Tablename c WHERE c.Col1 = c1.Col1 FOR XML PATH('')),1,1,'')FROM Tablename c1Wed, 25 Aug 2010 02:17:01 GMTTarun Jaggihttp://www.sqlservercentral.com/Forums/Topic973776-392-1.aspx[quote][b]tripri (8/23/2010)[/b][hr]Hi i got a table which has data likeTableCol1----col2----Col3X--------1-------aX--------1--------bX--------1--------cY--------2-------eY--------2--------fZ--------2-------gZ--------2-------hi should get an out put which looks likecol1---col2---col3x------1------a,b,cy------2-------e,fz------2--------g,hCan any one help me out with this...Thank you[/quote]Is this homework? what do you got so far?Mon, 23 Aug 2010 16:42:35 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic973776-392-1.aspxHi i got a table which has data likeTableCol1----col2----Col3X--------1-------aX--------1--------bX--------1--------cY--------2-------eY--------2--------fZ--------2-------gZ--------2-------hi should get an out put which looks likecol1---col2---col3x------1------a,b,cy------2-------e,fz------2--------g,hCan any one help me out with this...Thank youMon, 23 Aug 2010 16:31:46 GMTtripri