select * from #t1 across apply (select b.prodid,max(daytime)dt from ProductRateMarginLog b where b.daytime<a.daytime and a.prodid=b.prodid group by b.prodid) b
posted on 2013-03-20 14:20 习惯简单 阅读(160) 评论(0) 编辑 收藏 举报