Counts of Call Histories by UserID
Type: MS SQL Query
Description: This gives you a count by user for the calls they created a history for. In this case I limited the date range to the year 2007.
- SELECT
- ch.userid
- ,COUNT(*) AS Call_Count
- FROM conthist ch
- WHERE
- ch.rectype LIKE 'C%'
- AND YEAR(ch.ondate) = '2007'
- GROUP BY ch.userid
[link]
Leave a Reply
You must be logged in to post a comment.
