|
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()
|
|
|
