Yep, it was a dumb mistake.  I intended to run the reindex w/fillfactor of 90, but believe I ran it with 10 instead.  If you envoke re-orgs via maintenance plans, there...

Please disregard post.  Think I found the issue.  Thanks.

Sorry, forgot to respond sooner...

Ken, I thoroughly tested your solution and it works great!

I implemented this into a stored procedure, and made a slight modification where the user can pass an...

Thanks to everyone on their responses!

Ken, I think I may be able to use what you posted.  I created your test table, ran the query, and came up with the...

This is probably not the best way to do this, but you could do something similar to the following:

select top 1 alerg_id from assignments

where valid_from < '4/20/2007'   -- or your...