select
RewardId,
stuff((select ','+rtrim( EveryDay)+':'+rtrim( Statistic) from cr where t.RewardId=RewardId order by EveryDay for xml path('')),1,1,'')
from cr t
group by RewardId
本文共 232 字，大约阅读时间需要 1 分钟。
select
RewardId,
stuff((select ','+rtrim( EveryDay)+':'+rtrim( Statistic) from cr where t.RewardId=RewardId order by EveryDay for xml path('')),1,1,'')
from cr t
group by RewardId
转载于:https://www.cnblogs.com/Michael-W/p/3716796.html