convert(varchar
(10),date,111)就可以直接把日期提取出来还可以按日期排序,顺眼多了。附一分组统计语句
CREATE TABLE #tmpvote(tdate datetime,tcount int,tmobile varchar(30))
INSERT INTO #tmpvote select convert(varchar(30),stamp,111) as tpdate,count(mobile)
tpcount,mobile from tab_vote_his group by convert(varchar(30),stamp,111) ,mobile order by
tpdate
select *,convert(varchar(10),tdate,111) from #tmpvote
select count(DISTINCT tmobile),tdate from #tmpvote where tcount>=20 group by tdate
drop table #tmpvote
select name,sum(数量) 数量,仓库,日期 from #a group by name,仓库,日期
select name
,sum(数量) as '数量 '
,仓库
,convert(char(10),日期,120) as '日期 '
from a
group by name,仓库,convert(char(10),日期,120)
select [name],sum(数量)as '数量 ',仓库,convert(char(10),日期,120) as '日期 '
from data
group by [name],仓库,convert(char(10),日期,120)
elect name,sum(数量) 数量,仓库,convert(datetime,left(日期,10)) 日期 from #a
group by name,仓库,convert(datetime,left(日期,10))