Convert › F020
Records Request 214
CJIWave 3Dataset query (SQL Server)
SELECT i.beat, i.location_type, i.offense_code FROM incident i WHERE i.offense_code = '13A' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo
SELECT i.beat, i.location_type, i.offense_code FROM incident i WHERE i.offense_code = '13A' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo