top of page

SQL multi item Per date count

  • Writer: skarbnik
    skarbnik
  • Nov 4, 2015
  • 1 min read

SELECT date = CONVERT(DATE,[STARTDATETIME]), EVENT_VALUE_1, count (*)

FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN] where [STARTDATETIME] between '2015-09-06 00:01:00.000' and '2015-09-21 23:59:59.000'

and [IVR_POINT] in ('A10.2.20','A120.1.23')

GROUP BY CONVERT(DATE,[STARTDATETIME]), EVENT_VALUE_1

ORDER BY date;

Comments


Search By Tags
bottom of page