Actually I'm doing it like this:

insert into ERROR values (GETDATE())

select count(*)

from ERROR

WHERE errorcolumn

BETWEEN dateadd(ss,-30,getdate()) AND GETDATE()

order by error

Thanks for your quick replies.

One question: what is the best way to get the rows inserted in the last 10 seconds for example.

Let's assume that I have a table ERROR...