Yes thanks, I added those 3 indexes in one QA environment but the initial select of 20k records into a temp table still ran over an hour before I killed it I'll get into your other query suggestions tomorrow.

Tonight was installing Sql 2012 sp2 in production 🙂