level 1
方建明1989
楼主
SQL 语句
select
(select count(*) from History t1 where wwRetrievalMode = 'Delta'
and Value > 0.30
and TagName='JCD_D1'
and DateTime > t.统计日期
and DateTime < t.统计日期 + ' 23:59:59' )
from
(select
convert(varchar(10),DateTime,120) as 统计日期
from History t1
where wwRetrievalMode = 'Delta' and DateTime >'2014-12-05' and DateTime < '2015-01-05' and TagName='JCD_D1'
group by convert(varchar(10),DateTime,120)) t
SQL server 2000 查询不出数据，SQL Server 2008 可查询出结果，请问原因？
2015年01月06日 08点01分
1
select
(select count(*) from History t1 where wwRetrievalMode = 'Delta'
and Value > 0.30
and TagName='JCD_D1'
and DateTime > t.统计日期
and DateTime < t.统计日期 + ' 23:59:59' )
from
(select
convert(varchar(10),DateTime,120) as 统计日期
from History t1
where wwRetrievalMode = 'Delta' and DateTime >'2014-12-05' and DateTime < '2015-01-05' and TagName='JCD_D1'
group by convert(varchar(10),DateTime,120)) t
SQL server 2000 查询不出数据，SQL Server 2008 可查询出结果，请问原因？