Convert › F019
Records Request 209
CJIWave 3Dataset query (SQL Server)
SELECT i.incident_id, i.occurred_date, i.offense_code FROM incident i WHERE i.offense_code = '240' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo
SELECT i.incident_id, i.occurred_date, i.offense_code FROM incident i WHERE i.offense_code = '240' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo