Status of cases when cops leave

When a cop quits or gets fired, what happens to the cases he or she is investigating? Action 7 news anchor Royale Da took that question to the district attorney to find out; you may be surprised to learn the answer.