In fact I read about this new sqlserver 2005 function that would fit perfectly but my database still under sqlserver 2000 🙁

ROW_NUMBER () OVER (PARTITION BY storeid ORDER BY storeid)...