Thank you. This helped me alot.

I think this is the way to go:

select rank() OVER (ORDER BY quantity desc ,itemhqid ) as rank,storeID,itemhqid

from ##SalesData

order by rank

##Salesdata is a tempory table which i create. So does not need to be tempory.

I just need a way of giving each store a priorty number based on which sold...