My tables are pretty simple:

create table table1

(

col1 int,

_when datetime default getDate()

)

create table table2

(

col1 int,

_when datetime default getDate()

)

create table table3

(

col1 varchar(10),

_when datetime default getDate()

)

And let's insert some data:

insert into table1(col1) values(1)

insert into table1(col1) values(2)

insert into table1(col1) values(3)

insert into table2(col1) values(10)

insert into table2(col1) values(11)

insert into table2(col1) values(12)

insert into table3(col1) values('1')

insert into table3(col1) values('2')

insert into table3(col1) values('3')

Because the "_when" column is by default getDate(), I should have a whole bunch of rows that contain data and the time it was inserted.

What I want to do is to get a count of all rows in a table grouped by the "_when" column, like

table1 2013-12-12 10 -- table1 had 10 rows inserted on 12/12/2013

table1 2013-12-13 12 -- table1 had 12 rows inserted on 12/13/2013

table2 2013-01-01 34 -- table2 had 34 rows inserted on 01/01/2013