We have two screens, the new one (soon to be released but not yet) works fine, the old one (in production) shows a duplicate. Fortunately the screen pretty just shows the output from a store proc. Unfortunately thats 1,020 lines of stored proc, including generating 6 temporary tables, and adding 9 nine indexes on those temp tables. There are 45 joins to diagnose.
I thought I could find the individual that wrote the new screen and get his advice on the old one, surely he looked at it. Unfortunately not, 1,020 lines of code was too complicated, so they (wisely) rewrote it as a black box.
I may be some time...