title: How to show records which were created within 10mins apart
body: <p>How do i return records which were created on the same day within 10mins? I would like to show all items with a created date <code>smalldatetime</code>.</p>
  
  <p>I have tried this but it doesnt work:</p>
  
  <pre><code>SELECT NAME,
         TITLE,
         CREATED
  FROM   TABLE
  WHERE  CREATEDBY = 'Billy'
  GROUP  BY NAME,
            TITLE,
            CREATED,
            Datepart(YEAR, CREATED),
            Datepart(MONTH, CREATED),
            Datepart(DAY, CREATED),
            Datepart(HOUR, CREATED),
            ( Datepart(MINUTE, CREATED) / 10 ) 
  </code></pre>