Convert › F167
Request 069
CJIRetireDataset query (SQL Server)
SELECT i.occurred_date, i.beat, i.incident_id, i.reported_date FROM incident i WHERE i.offense_code IN ('13A','23F') AND i.location_type = 'Parking Lot' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo