拼的很。。。。。
select '0800:1600:1.00' as list union all   
select '0600:1400:2200:1.00' union all     
select '0800:2000:2.00' union all     
select '0800:4.00' union all     
select '0800:1.00' 

select replace(REVERSE(substring(REVERSE(list),
charindex(':',REVERSE(list)),
(len(list)-charindex(':',REVERSE(list))))),':',':'+REVERSE(substring(REVERSE(list),0,charindex(':',REVERSE(list))))+'；') 
from 
(
select '0800:1600:1.00' as list union all   
select '0600:1400:2200:1.00' union all     
select '0800:2000:2.00' union all     
select '0800:4.00' union all     
select '0800:1.00' 
)as tables


--------------------
800:1.00；1600:1.00；
600:1.00；1400:1.00；2200:1.00；
800:2.00；2000:2.00；
800:4.00；
800:1.00；

（所影响的行数为 5 行）