I want to trigger a workflow only when a value is updated in a list item, but not everytime the item is changed.
For example I have a column for approve/not approve and I want that to be the trigger not the other values in the item.
I know this particular example could be accomplished with a simple SQL update statement, but the actual use for what this code will become requires stepping through each record in the dataset.
You might also want to consider transactional replication - get rid of this concept of having to do anything manually, and also the idea that data could be up to 15 minutes out of date. I want to update 2nd database table when there is an insert in first database table .
I did nearly the same with the insert method and that worked quite fine.