title: tsql select closest date set
body: <p>I'm trying to select a set of dates that is closest to (including before and after) a specific date.</p>
  
  <p>I'm pretty close, all I want to do now is select the top 10 'Closeness' to 0... but I'm not sure how to do that.</p>
  
  <pre><code>BEGIN
  Declare @DateCenter datetime2 = '2011-03-30 00:15:00'
  Declare @DateStart datetime2 = DATEADD(day,-7,@DateCenter)
  Declare @DateEnd datetime2 = DATEADD(day,7,@DateCenter)
  SELECT TOP 30 *, DateDiff(hour, Utc, @DateCenter) as Closeness
  FROM [CheckIns]
  WHERE Utc BETWEEN @DateStart AND @DateEnd
  END
  </code></pre>