// Taxi Faults - Read from the Quetzalsc database.
// In this SQL statement, replace with the billing period:
//     yyyy = Year (eg 2011)
//     mm = Month (eg 10)
SELECT 'DOH' AS Owner1, 'DOH' AS Cust_ID, 1 AS Bill, Call.CallNumber, Call.LogDatTim, Call.LastName,
 Call.ConfigId, Call.Logon, Call.ITHelpUser,Call.CallSubject1, Call.CallSubject2, Call.CallSubject3
FROM Call
WHERE Year(Call.LogDatTim) = yyyy
AND Month(Call.LogDatTim) = mm
AND Call.CallSubject1 LIKE 'TAXI DIRECTORATE%'
ORDER BY Call.LogDatTim