Hi, Il start off by saying that this is not my area of expertise. I am trying to make a query thattakes all the calls etc for each employee in one table and displays each employees total calls, average call time, total call time etc for incoming and outgoing call in another table.. My IT person at my work dose not have the time to make this for me so any help would be Great. Bellow shows the names of each tables column names.
dbo.Time_Reports
Column Names
Date (Date)
Employee ID (nchar 10)
Total Incoming Calls (int)
Total Outgoing Calls (int)
Total Incoming Call Duration (time (7)
Total Outgoing Call Duration (time (7)
Total On Call Time (nvarchar 20)
Call Type (nvarchar 20)
WorkGroup