Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a nighly routine that append to a table the status of record for that night. Its creates an audit trail for the records stats. When the status becomes "C" we want to append to the table on the date (the nightly rountine) it became "C". But then we want to stop appending that specific record for all subequent nightly updates. Any ideas how to do this?
Thanks,
Stephen
No ideas? Did I explain what I need OK?
Stephen
Figured it out with concatenate and where not exists.
Stephen