|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have a large database (>100,000 records) of individual webpage views
for on 100 different PCs on a network. The records include pageID, PC
ID and a time/date stamp. The records are sorted first by PC ID then
time/date. I need each record to be numbered sequentially. Though I
managed to do this on the first set of records, when I append the
database with a new month of records then re-sort the records by PC ID
then time/date the record number will need to be renumbered to properly
include the new records.
How might I accomplish this renumbering after each monthly update?
|
|
|