I want to find out which records were created within a given period of time per user. For example I want to know if the user "georgev" (or any users) has created more than one record in this table within a 2 minute period.
Hopefully thsi will warm your brains this cold Monday morning
FROM tableName a
JOIN tableName b
ON a.created_by_user = b.created_by_user
AND a.datetime_created > b.datetime_created
AND a.datetime_created <= DateAdd(mi, 2, b.datetime_created)