Posted by onkelringnes on 10/01/63 11:39

Erland Sommarskog skrev:

> > Logic behind this:
> > Return row n where Time2 of Id=(n-1) < @Time < Time 1 of Id=(n) and same
> > VId.
>
<snip example>

> Here I've taken your description by the letter. I strongly suspect
> that in real life the ids are not contiguous. But since I don't know
> what the real plot is, I did not want to do guessworks.

Thanks for the effort. You're very right that the ids are not
contiguous so I may be better off do it in my application as ZeldorBlat
pointed out.
Anyway, I learned something new which is always a good thing :)

Johnny

[Back to original message]