Transact-SQL - Beginner Query Problem

I am trying to write a query to return the number of times a datetime variable is between two datetime values in a table...in my head it should look something like this...

declare @dateget datetime, @datestart datetime, @datestop datetime;

set @datestart = '20090101 00:00:00'
set @datestop = '20090131 23:59:59'
set @dateget = @datestart

while @dateget <= @datestop
begin
select count * from TABLE
where @dateget >= TABLE_VALUE1 and @dateget <= TABLE_VALUE2
\\OUTPUT @dateget, Count(*)//
Set @dateget=dateadd(ss,1,@dateget)
end

so the output would be ....

20090101 00:00:00 # of occurrences
20090101 00:00:01 # of occurrences
20090101 00:00:02 # of occurrences
.
.
.
20090131 23:59:59 # of occurrences

Any help would be great!!!!!

Group By