Call Counts for One or More Users Per Month
Type: MSSQL
Description: Call Counts for One or More Users Per Month
- SELECT
- ch.userid
- ,DATENAME(m,ch.ondate) AS Call_Month
- ,DATEPART(m,ch.ondate) AS Month_Num
- ,COUNT(*) AS Call_Count
- FROM conthist ch
- WHERE
- ch.userid = 'JSMITH'
- AND ch.rectype LIKE 'C%'
- AND YEAR(ch.ondate) = '2009'
- GROUP BY
- ch.userid
- ,DATENAME(m,ch.ondate)
- ,DATEPART(m,ch.ondate)
- ORDER BY
- DATEPART(m,ch.ondate)
[link]
Leave a Reply
You must be logged in to post a comment.
