使用 SQL的 for xml path来进行字符串拼接 (group by)
时间:2022-03-14 00:17
参考:
select convert(varchar(10),c.[STARTSPECDAY],120), (select [LeaveName]+‘ ‘ from ( select convert(varchar(10),a.[STARTSPECDAY],120) STARTSPECDAY,a.[LeaveName] from [test].[dbo].[View_GetSPDay] as a ) as b where convert(varchar(10),c.[STARTSPECDAY],120)=convert(varchar(10),b.[STARTSPECDAY],120) for xml path(‘‘) ) as course_name from [test].[dbo].[View_GetSPDay] as c group by convert(varchar(10),c.[STARTSPECDAY],120)