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