In this category of that table its only 56 records but there are other categories in the table which would contain much higher sets of data that I might need...

This particular DB is actually still in 2000, although most are in 2005 so apologies for posting to wrong forum. But using your same logic I can generate the row_number...