select distinct(datepart(month,convert(varchar(10),Consumetime,120))) as m ,sum(ConsumeTotal) as cout
from dbo.T_Consume
where datepart(year,convert(varchar(10),Consumetime,120))='2011' and Phone='13333333333'
group by datepart(month,convert(varchar(10),Consumetime,120))
