I want to construct SQL 2000 query to create new Table from a view to calculate the no of closed, opened, cancelled, and escalated calls per analyst on particular year say 2009.
The helpdesk view vw_helpdesk contains the following fields :
1- AnalystName (nvarchar)
2- CallAssignedDate (datetime)
4-CallStatus (closed,Opened, Escalated,canceled) (nvarchar)
I want to create new table called CallsStat with the following fields