0 Replies Latest reply: Oct 27, 2011 10:30 AM by Ismael Villegas II RSS

    Grouping by a Timestamps Date in SQL statement

    Ismael Villegas II

      I am hoping that this will be an easy question to answer. I am trying to group some data from a SQL table by date but the table only contains a timestamp.

      Below is an example of my script:

       

       

      LOAD

           ID,

           EmployeeCt;

      SQL Select

           ID,

           Timestamp,

           COUNT(Employee) AS EmployeeCt

      FROM dbo.Employees

      GROUP By ??????;

       

      Any help would be much appreciated. Thank you