> I think that SP is a simple and fast solution. Helen's query may be
>a bit slow under some circumstances.

Well, then what about

"select j.Employee, j.Job, j.Salary, j.EffDate from jobhist j
where NOT EXISTS(SELECT * from jobhist k
where j.EffDate < k.Effdate
and k.Employee = j.Employee)"


Will that also be slow?

Set