Miracle:
其实我是要做这个效果,写的太急,给搞乱了,你再优化下
[阅读: 434] 2006-09-04 08:27:43
select A.TheDate, B.Value Today, C.Value Yesterday
from (
select TheDate from T1
union
select DateAdd(day, 1, TheDate) from T1
) A
left join T1 B
on A.TheDate=B.TheDate
left join T1 C
on DATEDIFF(day,C.theDate,A.thedate)=1
order by A.TheDate asc
夫习拳艺者,对已者十之七八,对人者,仅十之二三耳。拳艺之道,深无止境。得其浅者,一人敌,得其深者,何尝不万人敌耶!
我的Google Picasa相册
我的新BLOG