在时间充足的情况,会经常到论坛上看看别人发是帖子,能够回答的就尽量回复,一起学习、成才,因为担心有时会忘记,所以记录下来。问题如下:
回答如下:
create table #test
(bm varchar(10),
xm varchar(10),
kqh varchar(10),
rq datetime)
go
insert into #test
values('XX办','Pj',999,'2016-10-13 07:00:05'),
('XX办','Pj',999,'2016-10-13 07:02:09'),
('XX办','Pj',999,'2016-10-13 07:08:55'),
('XX办','Pj',999,'2016-10-14 07:09:25'),
('XX办','Pj',999,'2016-10-14 07:50:45'),
('XX办','Pj',999,'2016-10-14 07:55:51')
select bm,xm,kqh,convert(varchar(10),rq,121),
stuff(
(
select ','+right(convert(varchar(16),rq,121),5)
from #test a
where a.bm=b.bm and convert(varchar(10),a.rq,121)=convert(varchar(10),b.rq,121) for XML path('')
),1,1,''
)
from #test b
group by bm,xm,kqh,convert(varchar(10),rq,121)
drop table #test