将数值转换成百分比

select 

convert(varchar(10),Cast(Cast(Today_Percent as decimal(10, 3))*100 as decimal(10, 1)))+'%' ,

convert(varchar(10),Cast(Cast(Month_Precent as decimal(10, 3))*100 as decimal(10, 1)))+'%' ,

convert(varchar(10),Cast(Cast(Year_Percent as decimal(10, 3))*100 as decimal(10, 1)))+'%' 

from High_Priority_Percent_Data_Temp  

where BU='ABU1' 

and

 [Date]

 between

 DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)

and getdate()