I'm working on a report which requires me to get both the previous and the next record for every record in the output table. Now, I do asc/peek and desc/peek in two queries, but it takes a long time because it's a big output. Is there a way to use peek and something else like peek to get the next record in just one query?
