Team,
I have SQL 2000 and working in ASP. I have a sql table named "Audit" with the following columns;
AgentName, Manager, Badge, Queue, Auditor and Week.
What I want is,
want to display totally 3 tables.
1st Table:
Auditor | No. Of Audits
here, i want to display the auditor name and the no. of audits he's done for the week. I am able to pull up auditor name with this command,
SELECT distinct auditor from audit where week = '200913' order by auditor However how will I get the no. of audits he's done for the current week.
Kindly help
Start Free Trial
