I have a database with several tables and I want to find out how many rows are added each day.
Each table has a field MaintDate which is the date the row was added. Therefore the query below would give what I want for Table1.
select maintdate,count(maintdate) As NumberofUpdates from Table1 where maintdate >20071001 group by maintdate
There are many tables and I want the output in tabular format e.g
Date Table1Updates, Table2Updates