Dear all,
I have a a local SQL server 2012 express version where I have a dedicated table which stored local ORDERS.
In this table named "SALESORDER" I have a Boolean field called Transfert. When an order is place, that field is set to FALSE.
Then I have an running NT service which pool every 15 s that SALESORDER table for new records where Transfert=FALSE.
Then for each records found, they are send to the cloud. Once a records get successfully send to the cloud, I need to set the Transfert field to TRUE.
Then what I need to do is having a trigger that when a record gets its Transfer field = True, I need to delete that record from local table because it has been successfully proceed.
How to do that efficiently ?
INFO : Just a remark that I am storing orders locally in order to delegate the sending cloud task to a different process for performance reason
Go to the complete details ...