Solved
How to update a record Using SQL SERVER UPDATE without updating identity field
The process established by the company I work for is that we have the document coming into a MAPPER, that links the incoming fields to the SQL SERVER UPDATE Snap. This tells the UPDATE snap which fie...
figured it out. the ID field needs to be assigned to $original.ID
The "orginal", which is case sensitive, lifts it into a sub-document in the json
which is then ignored by the SET, but you are still able to include it in the WHERE
(I had tried this already, but had typed it as Original, which didn't work, but revisited it once I found sometihng in the help for the SQL SERVER UPDATE Snap
