insert into [dbo].[Attence] values(‘200718‘,‘2021-09-01‘,‘08:30‘,‘17:30‘)
insert into [dbo].[Attence] values(‘200718‘,‘2021-09-02‘,‘08:31‘,‘17:30‘)
insert into [dbo].[Attence] values(‘200718‘,‘2021-09-03‘,‘08:32‘,‘17:30‘)
insert into [dbo].[Attence] values(‘200718‘,‘2021-09-04‘,‘08:33‘,‘17:30‘)
insert into [dbo].[Attence] values(‘200718‘,‘2021-09-05‘,‘08:34‘,‘17:30‘)
insert into [dbo].[Attence] values(‘200888‘,‘2021-09-01‘,‘08:55‘,‘17:33‘)
insert into [dbo].[Attence] values(‘200888‘,‘2021-09-02‘,‘08:56‘,‘17:34‘)
insert into [dbo].[Attence] values(‘200888‘,‘2021-09-03‘,‘08:33‘,‘17:35‘)
insert into [dbo].[Attence] values(‘200888‘,‘2021-09-04‘,‘08:44‘,‘17:36‘)
insert into [dbo].[Attence] values(‘200888‘,‘2021-09-05‘,‘08:22‘,‘17:37‘)
select * from (
select Code,CreateDate,max(StartTime)+‘-‘+max(EndTime) as beginwork from Attence
where CreateDate>‘2021-08-25‘
group by code,CreateDate) t
PIVOT ( MAX([beginwork]) FOR [CreateDate] IN ([2021-09-01],[2021-09-02],[2021-09-03],[2021-09-04],[2021-09-05],[2021-09-06]) ) piv