23 Rewrite my working SQL Script

Rewrite my working SQL Script

I am a weak SQL programmer, but this script does work. It is a very simple database of resumes. Using brute force of lots of temp tables and repeated joins, it runs very slowly. MS SQL 2008 I need you to rewrite it elegantly to produce the same result for larger tables. I expect this to be a 1-3 hour job for an experienced SQL guru. I expect to paste and run your code with little or no tweaking. Need this on Monday Aug 26.SQL Script 
“0.

Discount Code: 0

: +1 0 0-0

0..