Re: Need Help With an Update Script

IS there anyway to do this? <<

Put in the discharge date as soon as you know it, then put a VIEW on
the table that hides this date until the CURRENT_TIMESTAMP makes it
magically appear for the idiot that came up with this spec.

Remember, tables are not files; tables can be virtual (VIEWs, derived,
CTE, etc.) while files have to be materialized. There is no need to
write to disk storage over and over.
.