sqlserver stuff

最新推荐文章于 2024-08-09 04:16:12 发布

老骥伏枥志在千里o

最新推荐文章于 2024-08-09 04:16:12 发布

阅读量616

点赞数

本文链接：https://blog.csdn.net/thinkingby/article/details/48158797

版权

select  RecordOnly,EnableTime,EndTime,
(select top 1 IsAllowTransit from tp_CallCentMobileSetUp where RecordOnly=a.RecordOnly),
(select top 1 CreateName from tp_CallCentMobileSetUp where RecordOnly=a.RecordOnly),
(select top 1 CreateTime from tp_CallCentMobileSetUp where RecordOnly=a.RecordOnly),
stuff((select ','+UserName from tp_CallCentMobileSetUp b 
where a.RecordOnly=b.RecordOnly order by UserName for xml path('')),1,1,'') UseNames
 from tp_CallCentMobileSetUp a  group by RecordOnly,EnableTime,EndTime