PaulHamill
MIS
All
I have written a Stored Procedure to Run on a daily basis to record the number of records in each of the tables within my database. The ouput of this script is to a table and is as follows...
Date TableName NoOfRecords
23-04-2003 TableA 10
23-04-2003 TableB 50
24-04-2003 TableA 15
24-04-2003 TableB 60
I want to be able to work out the daily increase in records of each of the tables. Does anyone have any ideas,
Thanking you all in advance
I have written a Stored Procedure to Run on a daily basis to record the number of records in each of the tables within my database. The ouput of this script is to a table and is as follows...
Date TableName NoOfRecords
23-04-2003 TableA 10
23-04-2003 TableB 50
24-04-2003 TableA 15
24-04-2003 TableB 60
I want to be able to work out the daily increase in records of each of the tables. Does anyone have any ideas,
Thanking you all in advance