Un-expire a reserved Mark

Owned by Sufyan Maghur
Last updated: Oct 17, 2022
1 min read

Occasionally a mark is set to expired and it should not be.  Display the mark and set the mark status to issued (2) instead of expired (6).

-- Change the MARK_AUTH_STATUS_CODE to 1 (reserved) and change the INEFFECTIVE_DATE to whatever you wish (Future date)

SELECT *
FROM CARS_AUTHORIZATION
WHERE MARK = 'ILVM';