Thinking of you and your family and wishing you a speedy recovery!

Thanks again for replying.

1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information...

Thanks for replying.

1. We use the default isolation level - Read Committed.

2. I use INSERT INTO. (see below) I've heard about locking problems with SELECT INTO

3. I followed your advice...