title: SQL Server: Count based on date and two different times
body: <p>OS - WindowsXP</p>
  
  <p>SQL Server Management Studio 2008 R2</p>
  
  <p>I am trying to get a count of the number of projects based on the release date, NOT date and TIME.  However, some projects have the same release date but a different time and are treated as a separate project.  As long as the project has the same date, I want it to be counted.</p>
  
  <p>'Releasedate' on the server is a "datetime"</p>
  
  <pre><code>Select ProjectName, count(ProjectName) as Count, (Releasedate)
  From DBTable Where Releasedate &gt;= convert(nvarchar,(getdate())) 
  Group by   projectname,releasedt
  </code></pre>
  
  <p>Current Results:</p>
  
  <pre><code> ProjectName       Count        Releasedate
  
   Project_Nm_1      1             2010-03-27 00:00:00
   Project_Nm_1      1             2010-03-27 08:00:00
   Project_Nm_2      1             2010-03-27 00:00:00
   Project_Nm_2      1             2010-03-27 08:00:00
  </code></pre>
  
  <p>I would like to see:</p>
  
  <pre><code> Project_Nm_1      2             2010-03-27
   Project_Nm_2      2             2010-03-27 
  </code></pre>