Convert › F032
Request 071
CJIWave 3Dataset query (SQL Server)
SELECT i.disposition, i.cleared, i.occurred_date, i.beat, i.reported_date, i.incident_id FROM incident i WHERE i.offense_code IN ('13B','23H') AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo