• If my understanding is correct, and you're always after the next tick value, have you considered using LEAD (T-SQL), rather than doing a self join?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk