SQL multi item Per date count
- 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