select Numbers, CONVERT(varchar(100), SwipeDateTime, 111) 日期 ,时间 = stuff((select ','+CONVERT(varchar(100), SwipeDateTime, 108) from AttendanceTimeRecords where Number = t.Number and CONVERT(varchar(100), SwipeDateTime, 111) = CONVERT(varchar(100), t.SwipeDateTime, 111) for xml path('')), 1, 1, '') from AttendanceTimeRecords as t group by Numbers, CONVERT(varchar(100), SwipeDateTime, 111)这样?
,时间 = stuff((select ','+CONVERT(varchar(100), SwipeDateTime, 108) from AttendanceTimeRecords where Number = t.Number and CONVERT(varchar(100), SwipeDateTime, 111) = CONVERT(varchar(100), t.SwipeDateTime, 111) for xml path('')), 1, 1, '')
from AttendanceTimeRecords as t group by Numbers, CONVERT(varchar(100), SwipeDateTime, 111)这样?
刚查了手册,没有看明白