Let there is a table with fields
Actually in the real problem column named here
kind are in a UNIQUE index, but the case if only
kind) is UNIQUE would be also interesting.
Let a date
d is specified. I want to retrieve the data of given
kind which corresponds to the latest
startdate which is before
As far as I understand this cannot be efficiently done with views.
So, should it be done with a stored procedure? I am a novice in the topic of stored procedures. Your code would be welcome.