<t>Interesting information about scans and using a cursor.I tried version (a) SELECT TOP 1 DateTime, BidORDER BY [Bid] ASCSELECT TOP 1 DateTime, AskORDER BY [Ask] DESCagainst (b):select Time,bidPrice,askpricefrom Tabwhere bidprice = (select Max(bidprice) from tab) OR askprice = (select Min(askprice)...