select test,Convert(nvarchar(20),(Convert(decimal(18,2),count(1) * 100.0 /
(select count(1) from Table where CreatedTime >=DATEADD(MONTH,-1,GETDATE())))))+'%'
from Table
where CreatedTime >=DATEADD(MONTH,-1,GETDATE())
group by test
select test,Convert(nvarchar(20),(Convert(decimal(18,2),count(1) * 100.0 /
(select count(1) from Table where CreatedTime >=DATEADD(MONTH,-1,GETDATE())))))+'%'
from Table
where CreatedTime >=DATEADD(MONTH,-1,GETDATE())
group by test