The TOP 1 clause insures it won't fail, but it can be considered to select randomly from records with the same effective date. You could add a second order by clause if this was undesired. Since the meetings are one per year, this wasn't needed.
Randy Hersom
President, Habilitation Software Inc.