sqlserver按月汇总
select convert(varchar(50),datepart(year,InTime)) +'-'+convert(varchar(50),datepart(month,InTime)) as month ,count(1) as Qty,SiteID from FineDtl
group by datepart(year,InTime),datepart(month,InTime),SiteID
select convert(varchar(50),datepart(year,InTime)) +'-'+convert(varchar(50),datepart(month,InTime)) as month ,count(1) as Qty,SiteID from FineDtl
group by datepart(year,InTime),datepart(month,InTime),SiteID
