Aggregate function with DATE TYPE column

• sql_ques

  SSCommitted

  Points: 1546

  More actions

  January 20, 2014 at 3:17 am

  #281268

  Hi,

  I need to get monthly count of number of tickets closed. Is it possible to use COUNT() with DATETYPE field?

  SELECT

  ID,

  Environment

  ,count((RT.[type])) As 'Type'

  ,convert(varchar(5),SD.StartDate,110) AS [Month]

  FROM TABLENAME

  GROUP BY Date, Type

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 20, 2014 at 3:28 am

  #1681473

  It should be, but why count(<column name>) rather than Count(*)?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  January 21, 2014 at 7:57 am

  #1681935

  sql_ques (1/20/2014)

  ---

  Hi,

  I need to get monthly count of number of tickets closed. Is it possible to use COUNT() with DATETYPE field?

  SELECT

  ID,

  Environment

  ,count((RT.[type])) As 'Type'

  ,convert(varchar(5),SD.StartDate,110) AS [Month]

  FROM TABLENAME

  GROUP BY Date, Type

  Thanks

  You must put ID and Environment in the GROUP BY clause.

  Regards,

  IgorMi

  Igor Micev,My blog: www.igormicev.com