合并相同字段

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