In my table below, I have multiple records that share an incident number (201311476). I need to check the JUVENILE flag and if it is 1 (like the first record) I need to bypass this incident record entirely.
That may seem simple but when the bigwigs want it NOW it gets harder - way harder.
agency incident suffix rec type inv num JUVENILE
01 201311476 00 1 V -1 1
01 201311476 00 2 R -1 NULL
Thanks!
That may seem simple but when the bigwigs want it NOW it gets harder - way harder.
agency incident suffix rec type inv num JUVENILE
01 201311476 00 1 V -1 1
01 201311476 00 2 R -1 NULL
Thanks!