Convert › F162
Request 068
CJIRetireDataset query (SQL Server)
SELECT i.beat, i.reported_date, i.location_type, i.occurred_date, i.property_loss FROM incident i WHERE i.offense_code IN ('13B','23F','240') AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo