I've attached the execution plan as a .gif because I honestly couldn't figure out any other way to do it..........I looked at Kraig's guide and did as it said and pasted it into an excel spreadsheet.
Also, I tried creating an index on tfx_v2_unfiltered rates as follows
Timeinserted - asc
hotelid - asc
siteid - asc
It made the stored procedure actually run slower.
Query went from 16 seconds to 22 seconds.
Thanks
-Josh