Thanks for the comments on Nolock.

Well basically i use it because I've been learning sql for 6 months only, and this is what i have been shown by other members...

Thank you very much for the quick replies!

To clarify - I want top 25 by store.

so for example the report to show

store 1 - then list all top...