hi want output like below i have mention anyone have idea

Question

col1 col2 col2 m1 1 a m1 1 b m1 1 c m2 2 d m2 2 e m2 1 f output --------- m1 1abcf m2 2de

Khan Abrar Ahmed · Answer

Hi try this declare @table as table (col1 varchar(64)col2 intcol3 varchar(64)) insert into @table values ('m1'1'a')('m1'1'b')('m1'1'c') ('m2'2'd')('m2'2'e')('m1'1'f') select distinct col1col2( select col3+'' from @table t1 where t1.col2=t2.col2 and t1.col1=t2.col1 for xml path('')) from @table t2

Sumit Jolly · Answer

If you want it using database SQL SERVER then use FOR XML PATH You can google for examples on the same