I am using MS SQL Server as my data store. The PutSQL processor is great if we are clear about the kind of DB operation we want to perform ie. INSERT or UPDATE. But what if we want to do something like UPSERT or MERGE operation? eg. https://myadventuresincoding.wordpress.com/2016/01/05/sql-server-how-to-write-an-upsert-using-merge/ I can't find any suitable set of processors that can achieve this. Anyone done this before?
... View more