34,590
社区成员
发帖
与我相关
我的任务
分享
select sum(num) as num,sum(totalpage) as totalpage,
editor from (
select d.num,d.totalpage,c.editor
from t_volumerecord c
inner join (
select a.volumeid,count(b.id) as num,max(b.pagenum2) as totalpage
from t_volumerecord a inner join t_volumeitem b
on a.volumeid = b.volumeid
group by a.volumeid
) d on c.volumeid = d.volumeid where 1=1 and c.editor='***'
and cast(f.edittime as datetime) >='2007-05-01'
and cast(f.edittime as datetime) <'2008-03-01'
) e group by editor
declare @tb table(dt varchar(50))
insert into @tb select '2008-01-03'
insert into @tb select '2008-01-04'
insert into @tb select '2008-01-05'
insert into @tb select '2008-01-04 至 2008-01-06'
insert into @tb select '2008-01-06'
insert into @tb select '2008-01-07'
select * from @tb
where (charindex('至',dt)=0 and dt between '2008-01-04' and '2008-01-06') or
(charindex('至',dt)>0
and (cast(left(dt,10) as datetime) between '2008-01-04' and '2008-01-06')
and (cast(right(dt,10) as datetime) between '2008-01-04' and '2008-01-06'))
这样看行不?
isdate(f.edittime)>0 and cast(cast(f.edittime as varchar(10)) as datetime)
另外楼主确实强人,双胞胎,比较厉害。呵呵
select edittime from tb
where edittime not like '% % %'
and edittime not like '%-%-%'
and edittime not like '%至%'
cast(cast(f.edittime as varchar(10)) as datetime)