在一个stored procedure里,需要用一个sub query
找到最近的exchange rate
select datadate, price/a.rate
from #tempTable, exchangeTable as a
where a.date_ =(
select max(date_)
from exchangeTable
where date_ <= datadate
~~~~~~~~~~
)
and datadate between @start and @end
上面query的问题是datadate在sub query里面不能
reference. 有什么好的解决办法么?谢谢。