select [date]=convert(varchar(10),[date],120),sum(shu) as shu from a group by convert(varchar(10),[date],120)
select convert(varchar(10),[date],120) 'date',sum(shu) shu from a group by convert(varchar(10),[date],120)
select [date]=substring(date,1,(case when substring(date,9,1)='-' then 8 else charindex('-',date,9)-1 end)),sum(shu) as shu from a group by substring(date,1,(case when substring(date,9,1)='-' then 8 else charindex('-',date,9)-1 end))
convert(varchar(10),[date],120)
from a group by convert(varchar(10),[date],120)
when substring(date,9,1)='-' then 8 else charindex('-',date,9)-1 end)),sum(shu) as shu from a
group by substring(date,1,(case
when substring(date,9,1)='-' then 8 else charindex('-',date,9)-1 end))