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
Navigation:
[Reply to this message]
|