>Thanks Again Bruce for help, I'll start using the Nofilter clause and Deleted()indexes in the future.
Uh-oh - Perhaps I was a little bold about the usage of these two features. Both are "situational," and both can slow performance at times when used indiscriminantly. It's a rather complex topic...but if your tables are small, go ahead and use either or both, no harm will be done, and it will avoid the problems such as you had...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.