Al makes a good point. Let's see your table defintion.

12 seconds to three minutes is a huge difference; maybe your "dynamic" code isn't using the clustered indexed as expected. Did...

Please confirm your indexes on both tables:

Does each index contain just a phone number or do the indexes contain mutiple columns and if so, what are the columns?

Are the indexes...

Hi Thor.

Vladan makes a good point about not understanding your requirements here. I don't understand them either. It's helpful to all of us when you are posting a question like...

Thank you all for your help!

Eaton

Jeff,

I appreciate the feedback. I need to provide a little more detail on the requirements. First, the following is the correct output for the above inserts:

Ray, I appreciate the feedback. Do you recommend the books on-line specifically for a series of good SQL examples or was there another part of this web site that you...