Convert › F144
Request 067
CJIRetireDataset query (SQL Server)
SELECT i.offense_code, i.incident_id, i.occurred_date, i.reported_date, i.location_type FROM incident i WHERE i.offense_code IN ('13B','23F') AND i.property_loss > 2500 AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo