title: SQL Server - select rows that fall in this week
body: <p>I have the following code: </p>
  
  <pre><code>SELECT COUNT(INTERVIEW_ID) 
  FROM Interviews AS i INNER JOIN CVsSent AS cvt ON i.CVSENT_ID = cvt.CVSENT_ID  
  WHERE cvt.EMP_ID = e.EMP_ID 
  AND (i.DATE_TIME &gt;= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) 
  AND i.DATE_TIME &lt; DATEADD(day, DATEDIFF(day, 0, GETDATE()), 1)))
  AS INTERVIEW_COUNT_DAY
  </code></pre>
  
  <p>which selects a count for today. I need a query which selects a count for this week, starting from Sunday (day 1) finishing Saturday (day 7), as opposed to the last 7 days. Is this possible?</p>