I have a working query that shows me the total# of Request and whether they met the SLA for the running and last quarter. I want to get this data for all of 2009, on a per month basis.

Could someone show me how to adjust this to given me January, then Feb, March, etc?

Thanks,

SELECT COUNT(wo.WORKORDERID) 'Total',(SELECT COUNT(wo.WORKORDERID) FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID and wos.STATUSID=1 AND (wo.CREATEDTIME >= <from_thisquarter>) AND (wo.CREATEDTIME <= <to_thisquarter>)) 'Open',(SELECT COUNT(wo.WORKORDERID) FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID AND wos.STATUSID=3 AND (wo.CREATEDTIME >= <from_thisquarter>) AND (wo.CREATEDTIME <= <to_thisquarter>)) 'Closed', (SELECT COUNT(wo.WORKORDERID) FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID AND wos.STATUSID=3 and wo.COMPLETEDTIME > wo.DUEBYTIME AND (wo.CREATEDTIME >= <from_thisquarter>) AND (wo.CREATEDTIME <= <to_thisquarter>)) 'Not met SLA',(SELECT COUNT(wo.WORKORDERID) FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID AND wos.STATUSID=3 AND wo.COMPLETEDTIME < wo.DUEBYTIME AND (wo.CREATEDTIME >= <from_thisquarter>) AND (wo.CREATEDTIME <= <to_thisquarter>)) 'Closed within SLA' FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID AND (wo.CREATEDTIME >= <from_thisquarter>) AND (wo.CREATEDTIME <= <to_thisquarter>)