• Is it not possible to rank over the table once, and get everything you ever need from that table, instead of PolicyAudit self join (select top 1 PolicyAudit )?

    Top sets a row goal so could force the optimiser into doing silly things.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]