Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
USE [db1] DECLARE @endDate datetime DECLARE @startDate datetime SET @startDate = '2011-09-01 00:00:00.000' SET @endDate = '2011-09-30 23:59:59.997' SELECT convert(CHAR(10), SetupTime,104) as 'DATE / CAT' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) THEN 0 END) AS 'TOTAL' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) AND (LocationZoneID = 167) THEN 0 END) AS 'CFW' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) AND (LocationZoneID = 168) THEN 0 END) AS 'NAT' FROM [CDRData] WHERE (Direction = 1) AND (CallClass = 1) AND (SetupTime BETWEEN @startDate AND @endDate) GROUP BY convert(CHAR(10), SetupTime, 104) ORDER BY convert(DATETIME, convert(CHAR(10), SetupTime, 104), 104)
|how to import||7||54|
|2008 to 2016 SQL migration..||5||27|
|monitor queries that use too much tempdb log||20||35|
|Release Access 2010 Combo Box Row Source after user selects a value in the Combo Box||8||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!