Convert › F024
Request 111
CJIWave 2Dataset query (SQL Server)
SELECT i.cleared, i.occurred_date, i.reported_date, i.offense_code, i.disposition FROM incident i WHERE i.offense_code IN ('13B','35A') AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo