select Convert ( VARCHAR(7),CreateTime,120) as Date ,sum(Money) as M FROM [LBAmmeterDB].[dbo].Am_Task select Convert ( VARCHAR(7),CreateTime,120) as Da
select Convert ( VARCHAR(7),CreateTime,120) as Date ,sum(Money) as M FROM [LBAmmeterDB].[dbo].Am_Task select Convert ( VARCHAR(7),CreateTime,120) as Da