with x as(
select 1 col1, 'a' col2 union all
select 1, 'a' union all
select 1, 'a' union all
select 1, 'b' union all
select 1, 'c' union all
select 2, 'd' union all
select 2, 'd' union all
select 3, 'e' union all
select 3, 'e' union all
select 3, 'e' union all
select 5, 'f' union all
select 5, 'f'
)

select distinct col1,
(
select (select col2 from x where col1=z.col1 for xml path(''),type).value('.','varchar(max)')
) col2
from x z

with x as(
select 1 col1, 'a' col2 union all
select 1, 'a' union all
select 1, 'a' union all
select 1, 'b' union all
select 1, 'c' union all
select 2, 'd' union all
select 2, 'd' union all
select 3, 'e' union all
select 3, 'e' union all
select 3, 'e' union all
select 5, 'f' union all
select 5, 'f'
),
y as (
select *,row_number()over(order by (select 1)) r
from x
),
z as(
select * ,1 cnt, cast(col2 as varchar(max)) as res
from y where r=1 
union all
select y.*,cnt+1, case when z.col1=y.col1 then z.res+y.col2 else y.col2 end
from y,z where y.r=cnt+1
)
select col1,max(res) col2
from z
group by col1

				SELECT a.request_body_id, a.response_type_id,(select c.additional_info+CHAR(10)+CHAR(13) as 'data()' from dbo.tb_responses c where a.request_body_id=c.request_body_id AND a.response_type_id = c.response_type_id  order by c.additional_info for xml path('') ) as response_body
				FROM tb_responses a INNER JOIN tb_requests_body b ON a.request_body_id = b.id
				WHERE a.[status] = 'Q'
					AND a.[response_type_id] IN (6,12)
					AND b.request_datetime BETWEEN @sdatetime AND @sdatetime
				GROUP BY  a.request_body_id, a.response_type_id	

select c.additional_info+CHAR(10)+CHAR(13) as 'data()' from dbo.tb_responses c where a.request_body_id=c.request_body_id AND a.response_type_id = c.response_type_id  order by c.additional_info for xml path('')