>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...