Sorry all, I provided EP as .sql-plan not .xml

No hard feelings here, and thanks for the tips on how to properly posts perf issues.  

PMD

Ok, I hope I am doing this correctly.  I am providing the Execution Plan as .xml, and DDL of the tables and view in the queries.  There are no, indices,...

Thanks Jeff.  And go easy on me J. Drew, I don't post very often scripts for assistance, and as I've mentioned I inherited this code and DB.  Clearly, there are...

Thank you all for your responses.  All have been very helpful.  And forgive me, I lost my formatting somewhere between copy & paste, I will ensure its formatted better in...

Thank you both for replying.

Sean, what would an alternative be?