select Date=convert(char(10),a.Time,120),b.TimeType,a.ID
from AmountTime a,TimeType b
where convert(char(5),a.Time,108)
between convert(char(5),cast(b.TimeStart as datetime),108)
and convert(char(5),cast(b.TimeEnd as datetime),108)
from AmountTime a,TimeType b
where convert(char(5),a.Time,108)
between convert(char(5),cast(b.TimeStart as datetime),108)
and convert(char(5),cast(b.TimeEnd as datetime),108)
解决方案 »
- 数据库概念逻辑设计问题
- sql2000不能安装
- 请教下大神们 如何给此视图添加索引 !~~~~~~~~~~~~~~~~~~~~~~求解答!!~~~~~~~~~~~~
- *********在网上发现一篇文章 希望对新手有些帮助 老手看了 就笑一下 别瞧不起....*****
- 那条速度快?
- SQL 排序的问题 读取数据后想ID 重新从1开始排列
- 如何验证查询效率
- PB 有锁表或锁记录的语句吗?(SQL server 70), 独占锁和共享锁 ************
- 实习要搞数据库开发,可我只学过foxpro2.5~~~,现在想用vfp,能不能推荐一本好的,谢谢
- 请问如何将一个XML文件的数据读入道数据库里去?
- 急!感觉很难的问题,请帮忙,谢谢!
- 传递参数到IN 表达的查询
select Date=convert(char(10),a.Time,120),b.TimeType,a.ID
from AmountTime a,TimeType b
where convert(char(5),a.Time,108)
between b.TimeStart and b.TimeEnd
convert(varchar(10) ,c.Time ,120) as Date,
c.TimeType
c.ID
from
(select
b.TimeType ,
a.*
from
AmountTime a ,
TimeType b
where
convert(varchar(5),a.Time,108) between right('0'+b.TimeStart , 5) and right('0'+b.TimeEnd , 5) ) c
group by
convert(varchar(10) ,c.Time ,120) , c.TimeType
order by
convert(varchar(10) ,c.Time ,120) , c.TimeType