Jeff, this is the method I was looking for and the results in are in line with what I wanted.  Thank you so much for your help.

Thanks Steve.  I will study this.  I really appreciate you taking the time to put this together.

Thank you for this great list!  One keyboard shortcut I would like to add is CTRL+SHIFT+R.  This will refresh the intellisense cache to allow that new object you just created...

Thank you Sergiy for the suggestion.

Thank you for the input Frederico!

An update. The first thing I did was to change the @CODA and @WarrPolCusts to temp tables instead of table vars. This took the query right at 10...

Here is the t-sql in the store procedure that is running the query that is taking the time. The execution plan that is bad is what is produced base...

One other thing I noticed. I went back to see when the stats were last built on the TAB.tblWorkOrderSegInvoices table and it was today. I guess when I...

Thanks Jeff and Chris. I cannot thank you enough for taking your time to help me.

Chris, I did see that the table vars are causing the estimated rows to...

It looks like it may have been a while.

Attached is the query plan. The main query that is the trouble is Query 3. As you can...

Thank you Chris for offering to look at this. I'm running it now. I'm warning you now that its not pretty. I'll upload as soon as it...

Thanks for the reply. Looks like our PCs are controlled by GPOs on Windows updates. So I'm going to have to look into this more and give it...

ChrisM, you pulled that trick out of the bag just in time. I needed this for something I worked on today. Thank you taking the time to put...